APPS.PO_DOCUMENT_REVISION_GRP dependencies on PO_LINE_LOCATIONS

Line 1223: FROM PO_LINE_LOCATIONS POLL,

1219: INTO x_different
1220: from sys.dual
1221: where exists(
1222: select null
1223: FROM PO_LINE_LOCATIONS POLL,
1224: PO_LINE_LOCATIONS_ARCHIVE POLLA
1225: WHERE POLL.po_header_id = p_doc_id
1226: AND POLL.po_release_id is null -- Bug 3876235
1227: AND (p_line_id IS NULL OR POLL.po_line_id = p_line_id) --

Line 1224: PO_LINE_LOCATIONS_ARCHIVE POLLA

1220: from sys.dual
1221: where exists(
1222: select null
1223: FROM PO_LINE_LOCATIONS POLL,
1224: PO_LINE_LOCATIONS_ARCHIVE POLLA
1225: WHERE POLL.po_header_id = p_doc_id
1226: AND POLL.po_release_id is null -- Bug 3876235
1227: AND (p_line_id IS NULL OR POLL.po_line_id = p_line_id) --
1228: AND (p_line_location_id IS NULL OR POLL.line_location_id = p_line_location_id) --

Line 1314: FROM PO_LINE_LOCATIONS POLL,

1310: INTO x_different
1311: from sys.dual
1312: where exists(
1313: select null
1314: FROM PO_LINE_LOCATIONS POLL,
1315: PO_LINE_LOCATIONS_ARCHIVE POLLA
1316: WHERE POLL.po_header_id = p_doc_id
1317: AND POLL.po_release_id is null -- Bug 3876235
1318: AND (p_line_id IS NULL OR POLL.po_line_id = p_line_id) --

Line 1315: PO_LINE_LOCATIONS_ARCHIVE POLLA

1311: from sys.dual
1312: where exists(
1313: select null
1314: FROM PO_LINE_LOCATIONS POLL,
1315: PO_LINE_LOCATIONS_ARCHIVE POLLA
1316: WHERE POLL.po_header_id = p_doc_id
1317: AND POLL.po_release_id is null -- Bug 3876235
1318: AND (p_line_id IS NULL OR POLL.po_line_id = p_line_id) --
1319: AND (p_line_location_id IS NULL OR POLL.line_location_id = p_line_location_id) --

Line 1401: po_line_locations_all poll

1397: SELECT 'Y'
1398: INTO x_different
1399: FROM po_price_differentials pdf,
1400: po_price_differentials_archive pdfa,
1401: po_line_locations_all poll
1402: WHERE poll.po_header_id = p_doc_id
1403: AND poll.line_location_id = pdf.entity_id
1404: AND pdf.entity_type = 'PRICE BREAK'
1405: AND pdf.price_differential_id = pdfa.price_differential_id (+)

Line 1543: FROM PO_LINE_LOCATIONS POLL,

1539: INTO x_different
1540: from sys.dual
1541: where exists(
1542: select null
1543: FROM PO_LINE_LOCATIONS POLL,
1544: PO_LINE_LOCATIONS_ARCHIVE POLLA
1545: WHERE POLL.po_release_id = p_doc_id
1546: AND (p_line_location_id IS NULL OR POLL.line_location_id = p_line_location_id) --
1547: AND POLL.line_location_id = POLLA.line_location_id (+)

Line 1544: PO_LINE_LOCATIONS_ARCHIVE POLLA

1540: from sys.dual
1541: where exists(
1542: select null
1543: FROM PO_LINE_LOCATIONS POLL,
1544: PO_LINE_LOCATIONS_ARCHIVE POLLA
1545: WHERE POLL.po_release_id = p_doc_id
1546: AND (p_line_location_id IS NULL OR POLL.line_location_id = p_line_location_id) --
1547: AND POLL.line_location_id = POLLA.line_location_id (+)
1548: AND POLLA.latest_external_flag (+) = 'Y'