906: from sys.dual
907: where exists(
908: select null
909: FROM PO_LINES POL,
910: PO_LINES_ARCHIVE POLA
911: WHERE POL.po_header_id = p_doc_id
912: AND (p_line_id IS NULL OR POL.po_line_id = p_line_id) --
913: AND POL.po_line_id = POLA.po_line_id (+)
914: AND POLA.latest_external_flag (+) = 'Y'
1045: from sys.dual
1046: where exists(
1047: select null
1048: FROM PO_LINES POL,
1049: PO_LINES_ARCHIVE POLA
1050: WHERE POL.po_header_id = p_doc_id
1051: AND (p_line_id IS NULL OR POL.po_line_id = p_line_id) --
1052: AND POL.po_line_id = POLA.po_line_id (+)
1053: AND POLA.latest_external_flag (+) = 'Y'