[Home] [Help]
4: --This bug mainly solves most of the performance related issues reported
5: --in SQLREP.
6: --There are two kinds of fixes.
7: --NO_UNNEST is used in the inner query to prevent FTS on large tables.
8: --Introduction of AP_INVOICES_ALL,AP_SYSTEM_PARAMETERS_ALL to force an
9: --access path.
10: -- Private Variables
11: -- Declaring the global variables
12: g_debug_switch VARCHAR2(1) := 'N';
143: nvl(ASP.RECON_ACCOUNTING_FLAG,'N')
144: INTO p_using_accrual_basis,
145: p_using_cash_basis,
146: p_recon_acctg_flag
147: FROM ap_system_parameters ASP;
148:
149: --
150: debug_info := 'End Get_Accounting_Method';
151: IF g_debug_switch in ('y','Y') THEN
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
926: AND pl.invoice_id=ai.invoice_id
927: AND ai.org_id=asp.org_id
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'
944: and xte.source_id_int_1 = aip.check_id
945: and xte.entity_id = xe.entity_id
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
2950: and xte.source_id_int_1 =PL.invoice_id
2951: AND ai.invoice_id=pl.invoice_id