APPS.INV_RCV_STD_RCPT_APIS dependencies on PO_REQUISITION_LINES

Line 2650: , po_requisition_lines porl

2646: , NULL secondary_quantity --OPM Convergence temp
2647: FROM rcv_shipment_headers rsh
2648: , rcv_shipment_lines rsl
2649: , po_requisition_headers porh
2650: , po_requisition_lines porl
2651: , mtl_system_items msi
2652: , mtl_system_items msi1
2653: , mtl_units_of_measure mum
2654: WHERE rsh.receipt_source_code <> 'VENDOR'

Line 2761: po_requisition_lines prl

2757: IF p_shipment_header_id IS NULL THEN
2758: SELECT DISTINCT rsl.shipment_header_id
2759: INTO l_shipment_header_id
2760: FROM rcv_shipment_lines rsl,
2761: po_requisition_lines prl
2762: WHERE
2763: prl.requisition_header_id = p_req_header_id
2764: AND prl.requisition_line_id = rsl.requisition_line_id;
2765: ELSE

Line 4093: , po_requisition_lines porl

4089: , NULL secondary_quantity --OPM Convergence temp
4090: FROM rcv_shipment_headers rsh
4091: , rcv_shipment_lines rsl
4092: , po_requisition_headers porh
4093: , po_requisition_lines porl
4094: , mtl_system_items msi
4095: , mtl_system_items msi1
4096: , mtl_units_of_measure mum
4097: WHERE rsh.receipt_source_code <> 'VENDOR'

Line 8900: , po_requisition_lines prl

8896: BEGIN
8897: SELECT 2
8898: INTO l_lpn_flag
8899: FROM po_requisition_headers prh
8900: , po_requisition_lines prl
8901: , rcv_shipment_lines rsl
8902: , mtl_system_items msi1
8903: , mtl_system_items msi2
8904: WHERE prh.segment1 = p_req_num