DBA Data[Home] [Help]

APPS.INV_RCV_DIR_RCPT_APIS dependencies on PO_LINES_ALL

Line 4039: FROM po_lines_all pola

4035: AND msi.organization_id = p_organization_id
4036: AND wlpn.lpn_id = wlpnc.parent_lpn_id
4037: AND (
4038: wlpnc.source_line_id IN(SELECT pola.po_line_id
4039: FROM po_lines_all pola
4040: WHERE pola.po_header_id = NVL(p_po_header_id, pola.po_header_id))
4041: OR wlpnc.source_line_id IS NULL
4042: )) lpnc
4043: WHERE lpnc.inventory_item_id = mln.inventory_item_id(+)