DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 4857: FROM po_line_locations_archive_all PLL2, po_releases_all POR2, PO_HEADERS_GT POH

4853: - nvl(PLL2.quantity_cancelled,0) )
4854: * PLL2.price_override ) ) )
4855: , 0 )
4856: INTO l_previous_rel_archive_amount
4857: FROM po_line_locations_archive_all PLL2, po_releases_all POR2, PO_HEADERS_GT POH
4858: WHERE PLL2.po_release_id = POR2.po_release_id
4859: AND POR2.po_header_id = POH.po_header_id
4860: AND nvl(POR2.approved_flag, 'N') IN ('R','F')
4861: and NVL(PLL2.LATEST_EXTERNAL_FLAG,'N') = 'Y'