APPS.PO_DOCUMENT_REVISION_GRP dependencies on PO_LINES

Line 894: FROM PO_LINES POL,

890: INTO x_different
891: from sys.dual
892: where exists(
893: select null
894: FROM PO_LINES POL,
895: PO_LINES_ARCHIVE POLA
896: WHERE POL.po_header_id = p_doc_id
897: AND (p_line_id IS NULL OR POL.po_line_id = p_line_id) --
898: AND POL.po_line_id = POLA.po_line_id (+)

Line 895: PO_LINES_ARCHIVE POLA

891: from sys.dual
892: where exists(
893: select null
894: FROM PO_LINES POL,
895: PO_LINES_ARCHIVE POLA
896: WHERE POL.po_header_id = p_doc_id
897: AND (p_line_id IS NULL OR POL.po_line_id = p_line_id) --
898: AND POL.po_line_id = POLA.po_line_id (+)
899: AND POLA.latest_external_flag (+) = 'Y'

Line 1033: FROM PO_LINES POL,

1029: INTO x_different
1030: from sys.dual
1031: where exists(
1032: select null
1033: FROM PO_LINES POL,
1034: PO_LINES_ARCHIVE POLA
1035: WHERE POL.po_header_id = p_doc_id
1036: AND (p_line_id IS NULL OR POL.po_line_id = p_line_id) --
1037: AND POL.po_line_id = POLA.po_line_id (+)

Line 1034: PO_LINES_ARCHIVE POLA

1030: from sys.dual
1031: where exists(
1032: select null
1033: FROM PO_LINES POL,
1034: PO_LINES_ARCHIVE POLA
1035: WHERE POL.po_header_id = p_doc_id
1036: AND (p_line_id IS NULL OR POL.po_line_id = p_line_id) --
1037: AND POL.po_line_id = POLA.po_line_id (+)
1038: AND POLA.latest_external_flag (+) = 'Y'

Line 1366: po_lines_all pol

1362: SELECT 'Y'
1363: INTO x_different
1364: FROM po_price_differentials pdf,
1365: po_price_differentials_archive pdfa,
1366: po_lines_all pol
1367: WHERE pol.po_header_id = p_doc_id
1368: AND pol.po_line_id = pdf.entity_id
1369: AND pdf.entity_type in ('PO LINE', 'BLANKET LINE')
1370: AND pdf.price_differential_id = pdfa.price_differential_id (+)