Query to find Bank, Bank Account, and Bank Branches information-Oracle R12
Query to find Bank,Accounts and Bank Branches information
SELECT cba.bank_account_name "Bank Account Name",cba.bank_account_num "Bank Account Number",
HOW TO KEEP MIND CALM AND PEACEFUL
KEEP MIND CALM AND PEACEFUL
Being in a hurry all the time drains your energy. Getting caught up in things beyond your control stresses you out. If you’d like to reduce stress and become calm and cool and wanted to compose yourself, put the following 12 steps into practice will surely help you but you need to be little more patient.
1. Let it go.
This thing that seems like the end of the world right now? Stressing out about the situation you’re in won’t do any good because you’re already in it, so just let it go.Keep calm and carry on.
IF YOU CAN DREAM IT, YOU CAN ACHIEVE IT
IF YOU CAN DREAM IT, YOU CAN ACHIEVE IT
If you want to succeed in life, a very first thing you need to do is to "DREAM". "If
you can dream it, you can achieve it".
"Dreams are seeding of Reality"
The world is filled with lots of opportunity; you just have to be alert to get it noticed and start emphasizing on it.
Burning desire to be and to do is the starting point from which the dreamer must take off. There is difference between "WISHING" For a thing and being "READY" to receive it. No one is ready for a thing until and unless we believe that we can conquer it.
The state of mind must be belief and not just mere hope or wish. Our limitations to our own capacity are the boundaries we make in our mind about ourselves..
You can't connect the dots looking forward; you can only connect them by looking backwards.
So you have to trust that the dots will connect with your future. You have to trust in something your guts, destiny, karma or whatever thing you can blindly trust. Because believing those the dots will connect down the road will give you the confidence to follow your heart, even when it leads you off the well worn path, and that will make all the difference.
Your time is limited, so don't waste it living someone else's life.Don't let the noise of other's opinions drown out your inner voice. You've got to find what you love, and that is as truth for work as it is for your lovers...
People who are running towards their dream, life has a special kind of meaning for them.
One thing you will surely get in path towards you dream is ‘FAILURE’. It might be big enough to break you but I must tell you no failure will break us until and unless we want to get break down, every failure in life is there to make us. In the process of doing that, you will discover lots of things about yourself that you don’t know right now. What you will realize is that you have greatness within you. That you are more powerful that you can ever begin to imagine. That you are greater than your circumstances.
While you’re running towards your dream, I applaud you for believing in yourself. Because that’s what life is about. Stretching and challenging. Looking for ways that you can begin to improve yourself. Do it! Your dream is possible..!!
And Remember to Celebrate your successes.!!
Just don’t stop with little success keep improving, keep going from high to higher and keep achieving you Dreams.
Sharing with you one of my personal favorite inspirational video by Will Smith:
All The Best..!!
Meditation Health Benefits and Stress Reduction and basic techniques
Meditation Health Benefits and basic techniques
What is meditation?
Meditation is relaxation. It is not about concentration, it’s actually about de-concentration. It’s not about focussing one’s thoughts, but instead becoming thoughtless.Meditation is an approach to train the mind,similar to the way that fitness is an approach to train the body.
How to meditate: Simple meditation for beginners
- Sit,stand or lie comfortably (Prefered way is sitting). You may even use meditation chair,but sit with your back straight.There are lots of Meditation Posture which you can follow.
- Close your eyes.
- Make no effort to control the breath; simply breathe naturally.
- Focus your attention on the breath and on how the body moves with each inhalation and exhalation.Notice the movement of your body as you breathe. Observe your chest, shoulders, rib cage, and belly. Simply focus your attention on your breath without controlling its pace or intensity. If your mind wanders, return your focus back to your breath.
Maintain this meditation practice for two to three minutes to start, and then try it for longer periods.
What are the benefits of meditation?
- A calm mind
- Good concentration
- Better clarity
- Improved communication
- Relaxation and rejuvenation of the mind and body
With meditation, the physiology undergoes a change and every cell in the body is filled with more Prana (energy). This results in joy, peace, enthusiasm as the level of Prana in the body increases.
On a physical level, meditation
On a physical level, meditation
- Lowers high blood pressure.
- Lowers the levels of blood lactate, reducing anxiety attacks.
- Decreases any tension-related pain, such as, tension headaches, ulcers, insomnia, muscle and joint problems.
- Increases serotonin production that improves mood and behavior.
- Improves the immune system.
- Increases the energy level, as you gain an inner source of energy.
Mental Benefits of Meditation
- Anxiety decreases.
- Emotional stability improves.
- Creativity increases.
- Happiness increases.
- Intuition develops.
- Gain clarity and peace of mind.
- Problems become smaller.
- Meditation sharpens the mind by gaining focus and expands through relaxation.
- A sharp mind without expansion causes tension, anger and frustration.
- An expanded consciousness without sharpness can lead to lack of action/progress.
- The balance of a sharp mind and an expanded consciousness brings perfection.
- Meditation makes you aware - that your inner attitude determines your happiness.
Spiritual benefits of meditation
Meditation doesn’t have a religion and can be practiced by anybody.
- Effortless transition from being something to merging with the infinite and recognizing yourself as an inseparable part of the whole cosmos.
- In a meditative state, you are in a space of vastness, calmness and joy and this is what you emit into the environment, bringing harmony to the Creation/planet.
- Meditation can bring about a true personal transformation. As you learn more about yourself, you’ll naturally start discovering more about yourself.
Meditation requires no special equipment, and is not complicated to learn. It can be practiced anywhere, at any moment and it is not time consuming (15-20 min. per day is good). Best of all, meditation has NO negative side effects. Bottom line, there is nothing but positive to be gained from it! With such a huge list of benefits, the question you should ask yourself is, “why am I not meditating yet?”
If you need a point to start from, you should try guided meditation courses. They are inexpensive and can provide good foundation from were you can begin meditating.
Dive deep into yourself and enrich your life.Make sure you meditate, there are quite simply too many positives to just ignore it.Busy people from all backgrounds are grateful to pause and enjoy a refreshing few minutes of meditation each day.
Guys,specially students,just give 5 min less time to your mobile and spent that for yourself to do meditation believe me you will find yourself again.
5 Benefits of meditation for students
- Greater confidence
- More focus and clarity
- Better health
- More mental strength and energy
- Greater dynamism!
Meditation is like a seed. Cultivate a seed with love and it blossoms for sure.Also it is completely FREE!.. So go ahead and find your soul and keep smiling !! :)
Sharing Video for How to Meditate Properly and Improve Meditation Techniques :
Sharing Video for How to Meditate Properly and Improve Meditation Techniques :
Pretty URLs in AngularJS: Removing the Hashtag(#) tag
Remove Hashtag From The Routing URL
Whenever we write URL of an angular application , a hashtag ie (#) always appear after the application root folder
For Example: –
https://www.conflate.com /tutorial/angularjs/#/emp_details/0
In this Post, we will explain you how to remove hashtag from the routing URL. LIVE DEMO & GET WP THEME
In earlier application code, you have noticed that whenever you run the application through some URL, a hashtag, i.e /#/, will appear in the URL just after the application folder name, which looks ugly.
So, let’s remove this hashtag from the URL and make you URL more beautiful and comfortable to read.
For this, you need to do two changes in the application.
1. Configure $locationProvider service in the application module.
2. Add a base tag in head section the application.
Configure $locationProvider
$locationProvider is used to to configure the application module and tell it how to store deep linking path of the application.
It uses html5Mode() method with true as parameter to remove hashtag, i.e /#/, from the URL of the application.In Angular, the
$location
service parses the URL in the address bar and makes changes to your application and vice versa.Configuring $locationProvider will remove the hashtag from the application URL but, application will not load correctly. To resolve this, we will have to add a base tag in the head section of the index page.
The base tag has one property, href. Href contains the URL path up to the application root folder.
For Example:-
Let suppose a URL,
https://www.conflate.com/tutorial/angularjs/#/emp_details/0
Here, angularjs is the root folder of the application.
Then, we will write base tag as: –
<base href="https://www.conflate.com /tutorial/angularjs/"/>
After it, the application will load properly and the application URL will look something like
https://www.conflate.com /tutorial/angularjs/emp_details/0
You can refer how to remove hashtag from below video:
Thanks Guys,hope you got the concept for this little but very important trick. Apply it in your application and share your feedback with us.Also If you have more such tricks and solution feel free to share.
Query to find Form Personalization-oracle Apps R12
Query to find Form Personalization details by passing form name:
SELECT ffv.form_id "Form ID",
ffv.form_name "Form Name",
ffv.user_form_name "User Form Name",
ffv.description "Form Description",
ffcr.sequence "Sequence",
ffcr.description "Personalization Rule Name"
FROM fnd_form_vl ffv,
fnd_form_custom_rules ffcr
WHERE ffv.form_name = ffcr.form_name
AND ffv.form_name = :P_Form_Name
ORDER BY ffv.form_name, ffcr.sequence;
How to improve GPS signal on your Android device
Improve GPS signal on your Android device
Your GPS sensor lets your phone use
navigational apps, such as Google Maps, and location services to properly tag
your geographical location across apps.Good signal is crucial for navigation as
well as playing certain AR (augmented reality) games like Pokémon Go. So
here's how you can improve the GPS signal on your device.
What is GPS?
To know how to optimize your GPS it's helpful
to understand how it works. GPS stands for Global Positioning
System and was developed by the US Army in 1973, but in 1995 it
was released for civilian purposes. It was initially used with 24
satellites but now there are 31 GPS satellites in orbit.
GPS is basically a satellite based positioning system that is designed to calculate geographic coordinates based on timing information received from multiple satellites in the GPS constellation. GPS has a relatively slow Time To First Fix (TTFF), and from a cold start (meaning without a last known position), it can take a lot of time to download the data it needs from the satellites to calculate a position. A-GPS used by cellular networks shortens this time by using the cellular network to deliver the satellite data to the phone.
Your smartphone communicates with these
satellites via a GPS antenna, which is part of the hardware in the majority of
today's smartphones and tablets. This hardware is connected via a driver
with the software. Thus, there are three sources of error for the GPS
signal in the smartphone:
- The number of GPS satellites at the current location
- The quality of the GPS antenna in the smartphone
- The implementation of the driver in the operating system
Switch on 'High accuracy' mode :
To get the best possible signal, you have to
be prepared to use a bit more battery than normal. It's a necessary sacrifice,
and you can always reverse it later when you don't need to use GPS, like
when you're done Pokémon hunting. Enabling this is easy; just follow
a couple of steps and you'll be on your way.
Go into your Settings and
tap Location and ensure that your location services are
on. You should be able to toggle it at the top right hand of your screen. It
should be green and the button to the right.
Now the first category under Location should
be Mode, tap that and make sure it's set to High accuracy.
This uses your GPS as well as your Wi-Fi and mobile networks to estimate your
location. This will use more battery, but will utilize all available
methods to give you the most accurate location possible.
Ensure
'High accuracy' mode is toggled on for a good signal. |
Keep the GPS signal active:
One of the main problems that we
encountered when going from one app to another is that the GPS is turned
off to save battery. If for example you are playing Pokémon Go and want to
take a look at your latest messages, your GPS could be turned off.
However, you can keep the GPS signal
active. To do this you must install a GPS app. We recommend Connected
GPS. It's a simple app and does the trick. Bear in mind that doing this
could result in reduced battery life.
Find out if your GPS issues are hardware- or software-related :
With GPS Essentials, you can diagnose whether poor GPS
signal is due to a hardware or software issue. In the GPS Essentials
main menu, tap Satellites, then watch (with some amazement) your
phone connecting to satellites around the earth.
If no satellites appear,
then this could be due to interference from metallic objects around you, your
smartphone case, or your GPS hardware not working properly. If satellites
do appear, but your GPS is still out of whack, then this is a software issue,
and you should refer to the other tips in this article to help you.
See
if your GPS is connect to any satellites with GPS EssentialsRefresh your GPS Data :
Sometimes your device will get 'stuck' on
certain GPS satellites, even if they’re not within range, causing it not
to work properly. To fix this, you can use an app like GPS Status &
Toolbox to clear your
GPS data and to start connecting to satellites from scratch.
In the app, tap anywhere on the screen, then
tap the menu icon and hit Manage A-GPS state. Tap Reset,
then when that's finished go back into the Manage A-GPS state menu
and tap Download. Your GPS data should now be
refreshed, and if it starts playing up again then just repeat this process.
Get an external GPS receiver :
If your smartphone GPS is no longer sufficient it might
be worthwhile for you purchase an external receiver. This can be
coupled with the smartphone via Bluetooth and recharge with the same
charger. On Amazon the Garmin GLO GPS receiver costs around $100.
Click the link below to pick it up.
{To be frank i never used this ;) but if need high accuracy and your mobile to old to handle new GPS system then you can use this.}
Do you have any other tweaks to help improve GPS accuracy? If so, share them in the comments.
|
Query to Fetch Credit Card Details and CVV of a customer in oracle-R12
Query to fetch credit card details and secured CVV number
select hca.cust_account_id,
hca.party_id,
hcas.party_site_id,
hca.account_number "CUSTOMER",
CreditCardEO.CARD_ISSUER_CODE "CARD TYPE",
CreditCardEO.CCNUMBER "CARD NUMBER",
CreditCardEO.EXPIRYDATE "EXP DATE",
hp.party_name "OWNER NAME",
hcsu.location,
CreditCardEO.DESCRIPTION "CARDHOLDER NAME",
CreditCardEO.INVALIDATION_REASON,
trunc(ipiu.start_date) "VALID FROM",
(select iss.SEGMENT_CIPHER_TEXT
from apps.iby_fndcpt_tx_extensions extn,
IBY.IBY_SECURITY_SEGMENTS iss
where 1 = 1
and extn.instr_assignment_id = ipiu.instrument_payment_use_id
and extn.INSTR_CODE_SEC_SEGMENT_ID = iss.SEC_SEGMENT_ID
and rownum = 1) CVV
from apps.hz_cust_accounts_all hca,
apps.hz_cust_acct_sites_all hcas,
apps.hz_cust_site_uses_all hcsu,
apps.HZ_PARTY_SITE_USES hpsu,
apps.IBY_CREDITCARD CreditCardEO,
apps.IBY_PMT_INSTR_USES_ALL ipiu,
apps.hz_parties hp
where 1 = 1
and hca.party_id = hp.party_id
and hca.cust_account_id = hcas.cust_account_id
and hcas.cust_acct_site_id = hcsu.cust_acct_site_id
and hcas.party_site_id = hpsu.party_site_id
and hpsu.SITE_USE_TYPE = 'CC_BILLING'
AND CreditCardEO.INSTRID = ipiu.instrument_id
AND ipiu.INSTRUMENT_TYPE = 'CREDITCARD'
AND CreditCardEO.CARD_OWNER_ID = hp.party_id
and hcsu.site_use_code = 'BILL_TO'
and hcsu.org_id = 'required_operating_unit_id' -- pass operting unit id
order by customer, CreditCardEO.DESCRIPTION
{*Note : Before sharing cvv number,first check with proper requirement from security point of view and policy of your organization and client}.