DBA Data[Home] [Help]

APPS.JMF_SHIKYU_UTIL dependencies on PO_LINE_LOCATIONS_ALL

Line 150: , po_line_locations_all poll

146: AND sco.SUBCONTRACT_PO_SHIPMENT_ID IN
147: ( SELECT poll.line_location_id
148: FROM po_headers_all poh
149: , po_lines_all pol
150: , po_line_locations_all poll
151: WHERE poh.po_header_id = sco.SUBCONTRACT_PO_HEADER_ID
152: AND pol.po_line_id = sco.SUBCONTRACT_PO_LINE_ID
153: AND poll.line_location_id = sco.SUBCONTRACT_PO_SHIPMENT_ID
154: AND poll.po_header_id = sco.SUBCONTRACT_PO_HEADER_ID