DBA Data[Home] [Help]

APPS.PO_DOCUMENT_REVISION_GRP dependencies on PO_LINES_ARCHIVE

Line 910: PO_LINES_ARCHIVE POLA

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'

Line 1049: PO_LINES_ARCHIVE POLA

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'