APPS.INV_RCV_STD_RCPT_APIS dependencies on PO_REQUISITION_LINES

Line 2706: , po_requisition_lines porl

2702: , NULL secondary_quantity --OPM Convergence temp
2703: FROM rcv_shipment_headers rsh
2704: , rcv_shipment_lines rsl
2705: , po_requisition_headers porh
2706: , po_requisition_lines porl
2707: , mtl_system_items msi
2708: , mtl_system_items msi1
2709: , mtl_units_of_measure mum
2710: WHERE rsh.receipt_source_code <> 'VENDOR'

Line 2819: po_requisition_lines prl

2815: IF p_shipment_header_id IS NULL THEN
2816: SELECT DISTINCT rsl.shipment_header_id
2817: INTO l_shipment_header_id
2818: FROM rcv_shipment_lines rsl,
2819: po_requisition_lines prl
2820: WHERE
2821: prl.requisition_header_id = p_req_header_id
2822: AND prl.requisition_line_id = rsl.requisition_line_id;
2823: ELSE

Line 4274: , po_requisition_lines porl

4270: , NULL secondary_quantity --OPM Convergence temp
4271: FROM rcv_shipment_headers rsh
4272: , rcv_shipment_lines rsl
4273: , po_requisition_headers porh
4274: , po_requisition_lines porl
4275: , mtl_system_items msi
4276: , mtl_system_items msi1
4277: , mtl_units_of_measure mum
4278: WHERE rsh.receipt_source_code <> 'VENDOR'

Line 9296: , po_requisition_lines prl

9292: BEGIN
9293: SELECT 2
9294: INTO l_lpn_flag
9295: FROM po_requisition_headers prh
9296: , po_requisition_lines prl
9297: , rcv_shipment_lines rsl
9298: , mtl_system_items msi1
9299: , mtl_system_items msi2
9300: WHERE prh.segment1 = p_req_num