DBA Data[Home] [Help]

APPS.PO_AP_PURGE_PVT dependencies on AP_INVOICE_DISTRIBUTIONS

Line 1832: FROM ap_invoice_distributions AD

1828: AND (PD.last_update_date > p_last_activity_date
1829: OR
1830: EXISTS
1831: (SELECT NULL
1832: FROM ap_invoice_distributions AD
1833: WHERE AD.po_distribution_id =
1834: PD.po_distribution_id)))
1835: AND NOT EXISTS
1836: (SELECT NULL

Line 3007: ap_invoice_distributions AD

3003: WHERE PPL.double_check_flag = 'Y'
3004: AND EXISTS (
3005: SELECT NULL
3006: FROM po_distributions PD,
3007: ap_invoice_distributions AD
3008: WHERE PD.po_header_id = PPL.po_header_id
3009: AND AD.po_distribution_id = PD.po_distribution_id
3010: AND NOT EXISTS (
3011: SELECT NULL

Line 3416: FROM ap_invoice_distributions AD

3412: AND (PD.last_update_date > p_last_activity_date
3413: OR
3414: EXISTS
3415: (SELECT NULL
3416: FROM ap_invoice_distributions AD
3417: WHERE AD.po_distribution_id =
3418: PD.po_distribution_id))));
3419:
3420: ELSIF (p_purge_category = PO_AP_PURGE_GRP.G_PUR_CAT_MATCHED_PO_INV) THEN