DBA Data[Home] [Help]

APPS.INV_RCV_COMMON_APIS dependencies on MTL_SUPPLY

Line 5812: FROM po_requisition_lines_all prl, mtl_supply ms

5808: CONNECT BY parent_lpn_id = PRIOR lpn_id)
5809: AND wlc.parent_lpn_id = wln.lpn_id
5810: AND EXISTS(
5811: SELECT 1
5812: FROM po_requisition_lines_all prl, mtl_supply ms
5813: WHERE prl.requisition_header_id = p_requiition_header_id
5814: AND prl.requisition_header_id = ms.req_header_id
5815: AND prl.requisition_line_id = ms.req_line_id
5816: AND ms.supply_type_code = 'SHIPMENT'

Line 5836: FROM po_requisition_lines_all prl, mtl_supply ms

5832: START WITH lpn_id = p_lpn_id
5833: CONNECT BY parent_lpn_id = PRIOR lpn_id)
5834: AND EXISTS(
5835: SELECT 1
5836: FROM po_requisition_lines_all prl, mtl_supply ms
5837: WHERE prl.requisition_header_id = p_requiition_header_id
5838: AND prl.requisition_header_id = ms.req_header_id
5839: AND prl.requisition_line_id = ms.req_line_id
5840: AND ms.supply_type_code = 'SHIPMENT'