eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_R12_CAT_UPG_DEF_PVT dependencies on PER_EMPLOYEES_CURRENT_X

Line 1285: -- Bug#5389286 use PER_EMPLOYEES_CURRENT_X instead of POBUYERS_VAL_V

1281: -- SQL Join: org_id, business_group_id, agent_id
1282:
1283: -- Note: In this query, we need the sub query because the view PO_BUYERS_VAL_V
1284: -- does not have the column CREATION_DATE, on which we want to sort.
1285: -- Bug#5389286 use PER_EMPLOYEES_CURRENT_X instead of POBUYERS_VAL_V
1286: -- and collapsed 2 subqueries into 1 subquery to get newest valid
1287: -- buyer in the current business group
1288: FORALL i IN 1 .. x_headers_rec.po_header_id.COUNT
1289: INSERT INTO PO_SESSION_GT(key,

Line 1300: FROM PO_AGENTS BUYER, PER_EMPLOYEES_CURRENT_X HRE,

1296: SELECT agent_id
1297: FROM
1298: (
1299: SELECT BUYER.agent_id
1300: FROM PO_AGENTS BUYER, PER_EMPLOYEES_CURRENT_X HRE,
1301: HR_ALL_ORGANIZATION_UNITS HROU
1302: WHERE HRE.EMPLOYEE_ID = BUYER.AGENT_ID
1303: AND SYSDATE BETWEEN NVL(BUYER.START_DATE_ACTIVE, SYSDATE-1)
1304: AND NVL(BUYER.END_DATE_ACTIVE, SYSDATE+1)