APPS.PO_DOCUMENT_REVISION_GRP dependencies on PO_DISTRIBUTIONS_ARCHIVE

Line 1453: PO_DISTRIBUTIONS_ARCHIVE PODA,

1449: from sys.dual
1450: where exists(
1451: select null
1452: FROM PO_DISTRIBUTIONS POD,
1453: PO_DISTRIBUTIONS_ARCHIVE PODA,
1454: PO_LINE_LOCATIONS POLL --Bug 13960467
1455: WHERE POD.po_header_id = p_doc_id
1456: AND (POD.line_location_id = POLL.line_location_id) --Bug 13960467
1457: AND (p_line_id IS NULL OR POD.po_line_id = p_line_id) --

Line 1660: PO_DISTRIBUTIONS_ARCHIVE PODA

1656: from sys.dual
1657: where exists(
1658: select null
1659: FROM PO_DISTRIBUTIONS POD,
1660: PO_DISTRIBUTIONS_ARCHIVE PODA
1661: WHERE POD.po_release_id = p_doc_id
1662: AND (p_line_location_id IS NULL OR POD.line_location_id = p_line_location_id) --
1663: AND POD.po_distribution_id =
1664: PODA.po_distribution_id (+)

Line 2218: FROM po_distributions_archive_all poad

2214: AND 0= (SELECT Count(1)
2215: FROM po_distributions_all pod
2216: WHERE pod.line_location_id=p_line_location_id
2217: AND NOT EXISTS (SELECT po_distribution_id
2218: FROM po_distributions_archive_all poad
2219: WHERE pod.po_distribution_id=poad.po_distribution_id))
2220: UNION ALL
2221: SELECT line_location_id
2222: FROM po_line_locations_all

Line 2235: FROM po_distributions_archive_all poad

2231: AND 0= (SELECT Count(1)
2232: FROM po_distributions_all pod
2233: WHERE pod.po_line_id=p_line_id
2234: AND NOT EXISTS (SELECT po_distribution_id
2235: FROM po_distributions_archive_all poad
2236: WHERE pod.po_distribution_id=poad.po_distribution_id))
2237:
2238:
2239: UNION ALL

Line 2255: FROM po_distributions_archive_all poad

2251: AND 0= (SELECT Count(1)
2252: FROM po_distributions_all pod
2253: WHERE pod.po_header_id=p_doc_id
2254: AND NOT EXISTS (SELECT po_distribution_id
2255: FROM po_distributions_archive_all poad
2256: WHERE pod.po_distribution_id=poad.po_distribution_id))
2257:
2258:
2259:

Line 2276: FROM po_distributions_archive_all poad

2272: AND 0= (SELECT Count(1)
2273: FROM po_distributions_all pod
2274: WHERE pod.po_release_id=p_doc_id
2275: AND NOT EXISTS (SELECT po_distribution_id
2276: FROM po_distributions_archive_all poad
2277: WHERE pod.po_distribution_id=poad.po_distribution_id)));
2278:
2279: x_msg_type :='W';
2280:

Line 2315: FROM po_distributions_archive_all poad

2311: OR (0 <> (SELECT Count(1)
2312: FROM po_distributions_all pod
2313: WHERE pod.line_location_id=poll.line_location_id
2314: AND NOT EXISTS (SELECT po_distribution_id
2315: FROM po_distributions_archive_all poad
2316: WHERE pod.po_distribution_id=poad.po_distribution_id)
2317: )
2318: ))
2319:

Line 2330: po_distributions_archive_all poad

2326: OR Nvl(poll.quantity,0) <> Nvl(poall.quantity,0)
2327: OR Nvl(poll.amount,0) <> Nvl(poall.amount,0)))
2328: OR EXISTS (SELECT 'Enc Amount Changed'
2329: FROM po_distributions_all pod,
2330: po_distributions_archive_all poad
2331: WHERE pod.po_distribution_id=poad.po_distribution_id
2332: AND pod.line_location_id=poll.line_location_id
2333: AND poad.latest_external_flag ='Y'
2334: AND (Nvl(poad.encumbered_amount,0)<>Nvl(pod.encumbered_amount,0)