DBA Data[Home] [Help]

APPS.CTO_CHANGE_ORDER_PK dependencies on PO_HEADERS_ALL

Line 1445: po_headers_all poh,

1441: -- based on the Buyer on the PO
1442: CURSOR get_buyer_from_po(config_line_id IN NUMBER) IS
1443: select u.user_name
1444: from mtl_reservations mr,
1445: po_headers_all poh,
1446: oe_order_lines_all oel,
1447: fnd_user u
1448: where oel.line_id = config_line_id and
1449: mr.demand_source_type_id in (8,2) and

Line 1536: po_headers_all poh,

1532: SELECT mlk2.meaning supply_type,
1533: poh.segment1 job_number,
1534: pol.line_num line_number
1535: FROM mtl_reservations mr,
1536: po_headers_all poh,
1537: po_lines_all pol,
1538: po_line_locations_all poll,
1539: oe_order_lines_all oel,
1540: mtl_units_of_measure uom,

Line 1578: po_headers_all poh,

1574: SELECT mlk2.meaning Supply_type,
1575: poh.segment1 job_number,
1576: pol.line_num line_number
1577: FROM oe_drop_ship_sources ods,
1578: po_headers_all poh,
1579: po_line_locations_all poll,
1580: po_lines_all pol,
1581: oe_order_lines_all oel,
1582: mtl_units_of_measure uom,

Line 3289: po_headers_all poh,

3285: -- Cursor to get a unique user name based on the Buyer on the PO
3286: CURSOR get_buyer_from_po(config_line_id IN NUMBER) IS
3287: select u.user_name
3288: from mtl_reservations mr,
3289: po_headers_all poh,
3290: oe_order_lines_all oel,
3291: fnd_user u
3292: where oel.line_id = config_line_id and
3293: mr.demand_source_type_id in (8,2) and