DBA Data[Home] [Help]

APPS.INV_RCV_DIR_RCPT_APIS dependencies on PO_LINES_ALL

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(+)