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.CTO_CHANGE_ORDER_PK dependencies on PO_BUYERS_ALL_V

Line 1397: PO_BUYERS_ALL_V PBAV,

1393: -- Introdcued this to get a unique user name
1394: CURSOR get_buyer_user_name(inv_item_id NUMBER,ship_org_id NUMBER) IS
1395: SELECT FU.user_name
1396: FROM MTL_SYSTEM_ITEMS MTI,
1397: PO_BUYERS_ALL_V PBAV,
1398: FND_USER FU
1399: WHERE MTI.inventory_item_id = inv_item_id
1400: AND MTI.organization_id = ship_org_id
1401: AND MTI.buyer_id = PBAV.employee_id

Line 1578: -- bugfix 2203802: Instead of getting the full name directly from po_buyers_all_v

1574: IF PG_DEBUG <> 0 THEN
1575: oe_debug_pub.add('start_work_flow: ' || 'Getting buyer info..',1);
1576: END IF;
1577:
1578: -- bugfix 2203802: Instead of getting the full name directly from po_buyers_all_v
1579: -- get the corresponding application user.
1580:
1581: BEGIN
1582:

Line 1588: PO_BUYERS_ALL_V B,

1584: -- getting the value for user_name in the variable.
1585: /*SELECT u.user_name
1586: INTO lplanner_code
1587: FROM MTL_SYSTEM_ITEMS A,
1588: PO_BUYERS_ALL_V B,
1589: FND_USER U
1590: WHERE a.inventory_item_id = linv_item_id
1591: AND a.organization_id = lship_org_id
1592: AND a.buyer_id = b.employee_id