DBA Data[Home] [Help]

APPS.PO_CLOSEOUT_PVT dependencies on PO_LINES_ALL

Line 2260: po_lines_all pl

2256: AND pv.vendor_id = ph.vendor_id
2257: --Award should not contain any open shipments or line associated to the shipment is cancelled
2258: AND NOT EXISTS(SELECT 1
2259: FROM po_line_locations_all pll,
2260: po_lines_all pl
2261: WHERE pll.po_header_id = ph.po_header_id
2262: AND pll.po_line_id = pl.po_line_id
2263: AND (Nvl(pll.closed_code,'OPEN') IN ('OPEN')
2264: OR pl.user_document_status IS NOT NULL)

Line 2268: FROM po_lines_all pl

2264: OR pl.user_document_status IS NOT NULL)
2265: )
2266: --Award should not contain any unexcersized open options
2267: AND NOT EXISTS(SELECT 1
2268: FROM po_lines_all pl
2269: WHERE pl.po_header_id = ph.po_header_id
2270: AND pl.clm_option_indicator = 'O'
2271: AND Nvl(pl.CLM_EXERCISED_FLAG,'N') = 'N'
2272: AND (SYSDATE BETWEEN pl.start_date AND pl.expiration_date