DBA Data[Home] [Help]

APPS.RCV_SHIPMENT_LINES_PKG dependencies on PO_LINES_ALL

Line 545: po_lines_all pl

541: pd.destination_subinventory,
542: 'Y'
543: from po_distributions_all pd,
544: po_line_locations_all pll,
545: po_lines_all pl
546: where pd.po_distribution_id = dist_info.po_distribution_id
547: and pll.line_location_id = pd.line_location_id
548: and pl.po_line_id = pd.po_line_id
549: and nvl(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED'