DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RECONCILIAITON_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 375: , po_line_locations_all poll

371: , poll.need_by_date
372: , poll.SHIPMENT_NUM
373: FROM po_headers_all poh
374: , po_lines_all pol
375: , po_line_locations_all poll
376: WHERE poh.po_header_id = pol.po_header_id
377: AND pol.po_header_id = poll.po_header_id
378: AND pol.po_line_id = poll.po_line_id
379: AND poll.line_location_id = l_repl_po_shipment_id

Line 1396: , po_line_locations_all poll

1392: , trunc( wdj.SCHEDULED_START_DATE) SCHEDULED_START_DATE
1393: FROM JMF_SUBCONTRACT_ORDERS sco
1394: , po_headers_all poh
1395: , po_lines_all pol
1396: , po_line_locations_all poll
1397: , wip_discrete_jobs wdj
1398: WHERE pol.po_header_id = sco.SUBCONTRACT_PO_HEADER_ID
1399: and pol.po_line_id = sco.SUBCONTRACT_PO_LINE_ID
1400: and poll.po_line_id = pol.po_line_id