APPS.AP_PURGE_PKG dependencies on PO_DISTRIBUTIONS

Line 1269: po_distributions pd

1265: where ad.invoice_id = apl.invoice_id
1266: and ad.po_distribution_id is not null
1267: and not exists (select null
1268: from po_purge_po_list ppl,
1269: po_distributions pd
1270: where ppl.po_header_id =
1271: pd.po_header_id
1272: and pd.po_distribution_id =
1273: ad.po_distribution_id));

Line 1281: from ap_invoice_distributions ad,po_distributions pd

1277: update ap_purge_invoice_list apl
1278: set double_check_flag = 'N'
1279: where double_check_flag = 'Y'
1280: and exists (select /*+NO_UNNEST*/ null
1281: from ap_invoice_distributions ad,po_distributions pd
1282: where ad.invoice_id = apl.invoice_id
1283: AND pd.po_distribution_id=ad.po_distribution_id
1284: and ad.po_distribution_id is not null
1285: and not exists (SELECT null