DBA Data[Home] [Help]

APPS.INV_RCV_DIR_RCPT_APIS dependencies on PO_LINES

Line 401: , po_lines pol

397: , NULL secondary_uom_code --OPM Convergence
398: , pol.secondary_qty secondary_quantity --OPM Convergence
399: FROM po_headers poh
400: , po_line_locations poll
401: , po_lines pol
402: , po_releases por
403: , mtl_system_items msi
404: , mtl_units_of_measure mum
405: , po_distributions pod

Line 1019: , po_lines pol

1015: , NULL secondary_uom_code --OPM Convergence
1016: , pol.secondary_qty secondary_quantity --OPM Convergence
1017: FROM po_headers poh
1018: , po_line_locations poll
1019: , po_lines pol
1020: , po_releases por
1021: , mtl_system_items msi
1022: , mtl_units_of_measure mum
1023: , po_distributions pod

Line 3254: , po_lines pol

3250: FROM rcv_shipment_lines rsl
3251: , rcv_shipment_headers rsh
3252: , po_headers poh
3253: , po_line_locations poll
3254: , po_lines pol
3255: , po_releases por
3256: , mtl_system_items msi
3257: , mtl_units_of_measure mum
3258: , po_distributions pod

Line 4181: FROM po_lines_all pola

4177: AND msi.organization_id = p_organization_id
4178: AND wlpn.lpn_id = wlpnc.parent_lpn_id
4179: AND (
4180: wlpnc.source_line_id IN(SELECT pola.po_line_id
4181: FROM po_lines_all pola
4182: WHERE pola.po_header_id = NVL(p_po_header_id, pola.po_header_id))
4183: OR wlpnc.source_line_id IS NULL
4184: )) lpnc
4185: WHERE lpnc.inventory_item_id = mln.inventory_item_id(+)