APPS.AP_PURGE_PKG dependencies on PO_DISTRIBUTIONS

Line 1105: po_distributions pd

1101: where ad.invoice_id = apl.invoice_id
1102: and ad.po_distribution_id is not null
1103: and not exists (select null
1104: from po_purge_po_list ppl,
1105: po_distributions pd
1106: where ppl.po_header_id =
1107: pd.po_header_id
1108: and pd.po_distribution_id =
1109: ad.po_distribution_id));

Line 1117: from ap_invoice_distributions ad,po_distributions pd

1113: update ap_purge_invoice_list apl
1114: set double_check_flag = 'N'
1115: where double_check_flag = 'Y'
1116: and exists (select /*+NO_UNNEST*/ null
1117: from ap_invoice_distributions ad,po_distributions pd
1118: where ad.invoice_id = apl.invoice_id
1119: AND pd.po_distribution_id=ad.po_distribution_id
1120: and ad.po_distribution_id is not null
1121: and not exists (SELECT null