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 1417: PO_BUYERS_ALL_V PBAV,

1413: -- Introdcued this to get a unique user name
1414: CURSOR get_buyer_user_name(inv_item_id NUMBER,ship_org_id NUMBER) IS
1415: SELECT FU.user_name
1416: FROM MTL_SYSTEM_ITEMS MTI,
1417: PO_BUYERS_ALL_V PBAV,
1418: FND_USER FU
1419: WHERE MTI.inventory_item_id = inv_item_id
1420: AND MTI.organization_id = ship_org_id
1421: AND MTI.buyer_id = PBAV.employee_id

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

1765: IF PG_DEBUG <> 0 THEN
1766: oe_debug_pub.add('start_work_flow: ' || 'Getting buyer info..',1);
1767: END IF;
1768:
1769: -- bugfix 2203802: Instead of getting the full name directly from po_buyers_all_v
1770: -- get the corresponding application user.
1771:
1772: BEGIN
1773:

Line 1779: PO_BUYERS_ALL_V B,

1775: -- getting the value for user_name in the variable.
1776: /*SELECT u.user_name
1777: INTO lplanner_code
1778: FROM MTL_SYSTEM_ITEMS A,
1779: PO_BUYERS_ALL_V B,
1780: FND_USER U
1781: WHERE a.inventory_item_id = linv_item_id
1782: AND a.organization_id = lship_org_id
1783: AND a.buyer_id = b.employee_id

Line 3322: PO_BUYERS_ALL_V PBAV,

3318: --
3319: CURSOR get_buyer_user_name(inv_item_id NUMBER,ship_org_id NUMBER) IS
3320: SELECT FU.user_name
3321: FROM MTL_SYSTEM_ITEMS MTI,
3322: PO_BUYERS_ALL_V PBAV,
3323: FND_USER FU
3324: WHERE MTI.inventory_item_id = inv_item_id
3325: AND MTI.organization_id = ship_org_id
3326: AND MTI.buyer_id = PBAV.employee_id