DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 921: xla_transaction_entities xte, --Bug 4588031

917: DELETE FROM ap_purge_invoice_list PL
918: WHERE EXISTS (
919: Select 'invoice accounting not purgeable'
920: from xla_events xe, --Bug 4588031
921: xla_transaction_entities xte, --Bug 4588031
922: xla_ae_headers xeh, --Bug 4588031
923: ap_invoices_all ai,ap_system_parameters_all asp--bug5052748
924: where xte.entity_code = 'AP_INVOICES'
925: and xte.source_id_int_1 = PL.invoice_id

Line 939: xla_transaction_entities xte, --Bug 4588031

935: OR ( xeh.last_update_date > g_activity_date )))
936: OR EXISTS (
937: Select 'payment accounting not purgeable'
938: from xla_events xe, --Bug 4588031
939: xla_transaction_entities xte, --Bug 4588031
940: ap_invoice_payments aip,
941: ap_system_parameters_all asp,--bug5052478
942: xla_ae_headers xeh --Bug 4588031
943: where xte.entity_code = 'AP_PAYMENTS'

Line 2945: xla_transaction_entities xte,

2941: WHERE EXISTS (
2942: SELECT 'invoice accounting not purgeable'
2943: FROM xla_events xe,
2944: xla_ae_headers xeh,
2945: xla_transaction_entities xte,
2946: ap_invoices_all ai,
2947: ap_system_parameters_all asp --bug5052748
2948: where xte.entity_code = 'AP_INVOICES'
2949: and xte.entity_id = xe.entity_id

Line 2966: , xla_transaction_entities xte

2962: FROM xla_events xe
2963: , ap_invoice_payments aip
2964: , ap_checks apc
2965: , xla_ae_headers xeh
2966: , xla_transaction_entities xte
2967: WHERE xte.entity_code = 'AP_CHECKS'
2968: and xte.source_id_int_1 = apc.check_id
2969: and PL.invoice_id = aip.invoice_id
2970: and aip.check_id = apc.check_id