DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on XLA_AE_HEADERS

Line 1082: xla_ae_headers xeh, --Bug 4588031

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
1086: AND pl1.invoice_id=ai.invoice_id

Line 1104: xla_ae_headers xeh --Bug 4588031

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'
1106: and NVL(XTE.SOURCE_ID_INT_1,-99) = aip.check_id --11059839
1107: and xte.entity_id = xe.entity_id
1108: AND asp.set_of_books_id=xte.ledger_id

Line 3281: xla_ae_headers xeh,

3277: SET PL.double_check_flag = 'N'
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'

Line 3305: xla_ae_headers xeh --Bug 4588031

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'
3307: and NVL(XTE.SOURCE_ID_INT_1,-99) = aip.check_id --11059839
3308: and xte.entity_id = xe.entity_id
3309: AND asp.set_of_books_id=xte.ledger_id

Line 3324: , xla_ae_headers xeh

3320: SELECT 'payment accounting not purgeable'
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