APPS.PO_DOCUMENT_REVISION_GRP dependencies on PO_LINES

Line 909: FROM PO_LINES POL,

905: INTO x_different
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 (+)

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 1048: FROM PO_LINES POL,

1044: INTO x_different
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 (+)

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'

Line 1381: po_lines_all pol

1377: SELECT 'Y'
1378: INTO x_different
1379: FROM po_price_differentials pdf,
1380: po_price_differentials_archive pdfa,
1381: po_lines_all pol
1382: WHERE pol.po_header_id = p_doc_id
1383: AND pol.po_line_id = pdf.entity_id
1384: AND pdf.entity_type in ('PO LINE', 'BLANKET LINE')
1385: AND pdf.price_differential_id = pdfa.price_differential_id (+)

Line 2192: po_lines_all pol,

2188: FROM
2189: po_line_locations_archive_all poall,
2190: po_line_locations_all poll,
2191: po_headers_all poh,
2192: po_lines_all pol,
2193: po_distributions_all pod -----
2194: WHERE
2195: poll.line_location_id = pod.line_location_id -----
2196: AND poll.po_line_id = pol.po_line_id