DBA Data[Home] [Help]

APPS.RCV_INT_ORDER_PP_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 739: po_requisition_lines_all porl

735: rsl.po_line_location_id po_line_location_id,
736: rsl.employee_id employee_id
737: FROM rcv_shipment_headers rsh,
738: rcv_shipment_lines rsl,
739: po_requisition_lines_all porl
740: -- Following 2 lines are commented out for Bugfix 5201155
741: -- WHERE rsh.shipment_header_id = NVL(v_shipment_header_id, rsh.shipment_header_id)
742: -- AND NVL(rsh.shipment_num, '0') = NVL(v_shipment_num, NVL(rsh.shipment_num, '0'))
743: WHERE rsh.shipment_header_id = v_shipment_header_id -- Bugfix 5201155

Line 764: po_requisition_lines_all porl

760: ) IS
761: SELECT COUNT(*) AS line_count
762: FROM rcv_shipment_headers rsh,
763: rcv_shipment_lines rsl,
764: po_requisition_lines_all porl
765: -- Following 2 lines are commented out for Bugfix 5201155
766: -- WHERE rsh.shipment_header_id = NVL(v_shipment_header_id, rsh.shipment_header_id)
767: -- AND NVL(rsh.shipment_num, '0') = NVL(v_shipment_num, NVL(rsh.shipment_num, '0'))
768: WHERE rsh.shipment_header_id = v_shipment_header_id -- Bugfix 5201155