DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 1081: xla_transaction_entities xte, --Bug 4588031

1077: pl1.rowid -- 7759218
1078: from ap_purge_invoice_list pl1,
1079: ap_invoices_all ai,
1080: xla_events xe, --Bug 4588031
1081: xla_transaction_entities xte, --Bug 4588031
1082: xla_ae_headers xeh, --Bug 4588031
1083: ap_system_parameters_all asp--bug5052748
1084: where xte.entity_code = 'AP_INVOICES'
1085: and NVL(XTE.SOURCE_ID_INT_1,-99) = PL1.invoice_id --11059839

Line 1101: xla_transaction_entities xte, --Bug 4588031

1097: Select /*+ ORDERED PARALLEL(pl1) FULL(pl1) */
1098: pl1.rowid -- 7759218
1099: from ap_purge_invoice_list pl1,
1100: xla_events xe, --Bug 4588031
1101: xla_transaction_entities xte, --Bug 4588031
1102: ap_invoice_payments aip,
1103: ap_system_parameters_all asp,--bug5052478
1104: xla_ae_headers xeh --Bug 4588031
1105: where xte.entity_code = 'AP_PAYMENTS'

Line 3282: xla_transaction_entities xte,

3278: WHERE EXISTS (
3279: SELECT 'invoice accounting not purgeable'
3280: FROM xla_events xe,
3281: xla_ae_headers xeh,
3282: xla_transaction_entities xte,
3283: ap_invoices_all ai,
3284: ap_system_parameters_all asp --bug5052748
3285: where xte.entity_code = 'AP_INVOICES'
3286: and xte.entity_id = xe.entity_id

Line 3302: xla_transaction_entities xte, --Bug 4588031

3298: /* Changed the subquery - bug 12955426. Now the delete stmt (in Do_independent_inv_checks())
3299: and update stmt (in Retest_Invoice_Independents()) has same queries. */
3300: Select 'payment accounting not purgeable' -- 7759218
3301: from xla_events xe, --Bug 4588031
3302: xla_transaction_entities xte, --Bug 4588031
3303: ap_invoice_payments aip,
3304: ap_system_parameters_all asp,--bug5052478
3305: xla_ae_headers xeh --Bug 4588031
3306: where xte.entity_code = 'AP_PAYMENTS'

Line 3325: , xla_transaction_entities xte

3321: FROM xla_events xe
3322: , ap_invoice_payments aip
3323: , ap_checks apc
3324: , xla_ae_headers xeh
3325: , xla_transaction_entities xte
3326: WHERE xte.entity_code = 'AP_CHECKS'
3327: and NVL(XTE.SOURCE_ID_INT_1,-99) = apc.check_id --Bug#12615876
3328: and PL.invoice_id = aip.invoice_id
3329: and aip.check_id = apc.check_id