DBA Data[Home] [Help]

APPS.RCV_INT_ORDER_PP_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 782: po_requisition_lines_all porl

778: rsl.po_line_location_id po_line_location_id,
779: rsl.employee_id employee_id
780: FROM rcv_shipment_headers rsh,
781: rcv_shipment_lines rsl,
782: po_requisition_lines_all porl
783: -- Following 2 lines are commented out for Bugfix 5201155
784: -- WHERE rsh.shipment_header_id = NVL(v_shipment_header_id, rsh.shipment_header_id)
785: -- AND NVL(rsh.shipment_num, '0') = NVL(v_shipment_num, NVL(rsh.shipment_num, '0'))
786: WHERE rsh.shipment_header_id = v_shipment_header_id -- Bugfix 5201155

Line 809: po_requisition_lines_all porl

805: ) IS
806: SELECT COUNT(*) AS line_count
807: FROM rcv_shipment_headers rsh,
808: rcv_shipment_lines rsl,
809: po_requisition_lines_all porl
810: -- Following 2 lines are commented out for Bugfix 5201155
811: -- WHERE rsh.shipment_header_id = NVL(v_shipment_header_id, rsh.shipment_header_id)
812: -- AND NVL(rsh.shipment_num, '0') = NVL(v_shipment_num, NVL(rsh.shipment_num, '0'))
813: WHERE rsh.shipment_header_id = v_shipment_header_id -- Bugfix 5201155