APPS.PO_DOCUMENT_REVISION_GRP dependencies on PO_DISTRIBUTIONS_ARCHIVE_ALL

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)