DBA Data[Home] [Help]

APPS.PO_HEADERS_SV2 dependencies on PO_LINES_ALL

Line 603: po_lines_all POL

599:
600: SELECT 'Y'
601: INTO l_invalid
602: FROM po_headers_all POH,
603: po_lines_all POL
604: WHERE POL.contract_id = p_po_header_id
605: AND POL.po_header_id = POH.po_header_id
606: AND TRUNC(POL.creation_date) NOT BETWEEN
607: NVL(TRUNC(p_start_date), POL.creation_date - 1)