DBA Data[Home] [Help]

APPS.JMF_SHIKYU_PO_PVT dependencies on PO_LINES_ALL

Line 186: , po_lines_all pol

182: CURSOR c_po IS
183: SELECT poll.line_location_id
184: FROM po_line_locations_all poll
185: , po_headers_all poh
186: , po_lines_all pol
187: WHERE poll.po_header_id = poh.po_header_id
188: AND poll.po_line_id = pol.po_line_id
189: AND pol.line_reference_num = p_subcontract_po_shipment_id || '-' || l_interface_line_id
190: AND poh.reference_num = p_subcontract_po_shipment_id || '-' || l_interface_header_id