testoag

How can find Locked Object in Oracle Apps R12 ? or  How can find Locked object name and Oracle User name in Oracle Apps R12? Query 1 - SELECT b.owner      , b.object_name      , a.oracle_username      , a.os_user_name FROM   v$locked_object a      , all_objects b WHERE  a.object_id = b.object_id Query 2 - SELECT c.owner      , c.object_name      , c.object_type      , b.SID      , b.serial#      , b.status      , b.osuser      , b.machine FROM   v$locked_object a      , v$session b      , dba_objects c WHERE  b.SID = a.session_id AND    a.object_id = c.object_id; Query 3 - SELECT a.session_id      , a.oracle_username      , a.os_user_name      , b.owner "OBJECT OWNER"      , b.object_name    ...

Query to find Is an employee also a buyer or not In Oracle Apps R12? Query - SELECT pa.agent_id, papf.person_id, papf.employee_number, papf.email_address,        pa.category_id, pa.location_id, papf.effective_start_date,        papf.effective_end_date   FROM po_agents pa, per_all_people_f papf, hr_all_organization_units haou  WHERE pa.agent_id = papf.person_id    AND papf.business_group_id = haou.business_group_id    AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date                            AND papf.effective_end_date --AND    email_address = 'user@oag.com' --AND PAPF.EFFECTIVE_END_DATE > SYSDATE --AND HAOU.BUSINESS_GROUP_ID = 100 “A GUIDE FOR ORACLE E-BUSINESS SUITE” –A complete Solution and Learning platform For Oracle Apps R12/11i, Training, India Localization, Technical, P2P, O2C, Drop-shipment, AR/AP Cycle, Implementation, Bu...