Oracle applications
oracle e-business suite [sql,plsql,ora-apps,reports,forms(oaf,adf)]
Labels
adf
apps
bip
EDI
oaf
OBIEE
ODI
pl\sql
Reports
Rtf
sql
URL's
Thursday, September 29, 2016
To find locks in Oracle Database
select * from dba_locks;
select * from dba_locks where blocking_others!='Not Blocking';
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
SQL Query to get Quantity On Hand of any item
SELECT item.segment1 item_code, item.description item_description, SUM (on_hand.on_hand) on_hand FROM mtl_system_items_...
Error You are trying to access a page that is no longer active. - The referring page may have come from a previous session. Please select Home to proceed.
The root cause of this error are the profile options: 1) FND_VALIDATION_LEVEL - None 2) FND_FUNCTION_VALIDATION_LEVEL - None 3)Framework...
Join Relations Between tables in O2C
1------------HEADER_ID------------ select * from oe_order_headers_all; select * from oe_order_lines_all; 2---------CUSTOMER_ID-----SOLD...
No comments:
Post a Comment