DBA Data[Home] [Help]

APPS.JMF_SHIKYU_UTIL dependencies on PO_LINES_ALL

Line 149: , po_lines_all pol

145: WHERE sco.INTERLOCK_STATUS IN ('N','E','U' )
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