DBA Data[Home] [Help]

APPS.CTO_CHANGE_ORDER_PK dependencies on PO_REQUISITION_LINES_ALL

Line 1463: po_requisition_lines_all porl,

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
1467: mr.demand_source_type_id in (8,2) and

Line 1559: po_requisition_lines_all porl,

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
1563: WHERE oel.line_id = p_line_id

Line 1599: po_requisition_lines_all porl,

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
1603: WHERE oel.line_id = p_line_id

Line 3305: po_requisition_lines_all porl,

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
3309: mr.demand_source_type_id in (8,2) and