DBA Data[Home] [Help]

APPS.CTO_CHANGE_ORDER_PK dependencies on PO_REQUISITION_HEADERS_ALL

Line 1462: po_requisition_headers_all porh,

1458: -- based on the Buyer on the PO req line
1459: CURSOR get_buyer_from_po_req_line(config_line_id IN NUMBER) IS
1460: select u.user_name
1461: from mtl_reservations mr,
1462: po_requisition_headers_all porh,
1463: po_requisition_lines_all porl,
1464: oe_order_lines_all oel,
1465: fnd_user u
1466: where oel.line_id = config_line_id and

Line 1558: po_requisition_headers_all porh,

1554: SELECT mlk2.meaning Supply_type,
1555: porh.segment1 job_number,
1556: porl.line_num line_number
1557: FROM mtl_reservations mr,
1558: po_requisition_headers_all porh,
1559: po_requisition_lines_all porl,
1560: oe_order_lines_all oel,
1561: mtl_units_of_measure uom,
1562: mfg_lookups mlk2

Line 1598: po_requisition_headers_all porh,

1594: SELECT mlk2.meaning Supply_Type,
1595: porh.segment1 job_number,
1596: porl.line_num line_number
1597: FROM oe_drop_ship_sources ods,
1598: po_requisition_headers_all porh,
1599: po_requisition_lines_all porl,
1600: oe_order_lines_all oel,
1601: mtl_units_of_measure uom,
1602: mfg_lookups mlk2

Line 3304: po_requisition_headers_all porh,

3300: -- To get a unique user name based on the Buyer on the PO req line
3301: CURSOR get_buyer_from_po_req_line(config_line_id IN NUMBER) IS
3302: select u.user_name
3303: from mtl_reservations mr,
3304: po_requisition_headers_all porh,
3305: po_requisition_lines_all porl,
3306: oe_order_lines_all oel,
3307: fnd_user u
3308: where oel.line_id = config_line_id and