ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470A451A9E05362FB09050512Y SELECT AEH.LEDGER_ID LEDGER_ID , GLL.NAME LEDGER_NAME -- the following two columns are intentionally kept null as there is a -- possibility that the following query will not perform and then -- we will have to rely on this information coming from transfer package -- In that case we will not be able to provide this information. -- If this query performs okay, the two null columns can be replaced by -- actual values. , NULL BALANCE_TYPE_CODE , NULL BALANCE_TYPE , COUNT(DECODE(AEH.GL_TRANSFER_STATUS_CODE,'Y',1,NULL)) JE_TRANSFERRED_COUNT , COUNT(DECODE(AEH.GL_TRANSFER_STATUS_CODE,'Y',NULL,1)) JE_NOT_TRANSFERRED_COUNT FROM XLA_AE_HEADERS AEH , GL_LEDGERS GLL --, XLA_LOOKUPS XLK WHERE AEH.APPLICATION_ID = :APPLICATION_ID AND AEH.REQUEST_ID = &P_REQ_ID AND GLL.LEDGER_ID = AEH.LEDGER_ID AND AEH.GROUP_ID IN (&P_GROUP_ID_STR) --AND XLK.LOOKUP_TYPE = 'XLA_BALANCE_TYPE' --AND XLK.LOOKUP_CODE = AEH.BALANCE_TYPE_CODE GROUP BY AEH.LEDGER_ID ,GLL.NAME --,AEH.BALANCE_TYPE_CODE --,XLK.MEANING JL JLARAPTR PTB JL Transferir Lançamentos para o GL do AR e AP da América Latina Imported from BI Publisher Description: Use este programa para realizar a transferência para lançamentos do sub-razão do GL gerados por execuções anteriores do programa de criação contábil. Application: Localizações da América Latina Source: Transferir Lançamentos para o GL do AR e AP da América Latina Short Name: JLARAPTR DB package: XLA_CREATE_ACCT_RPT_PVT US JL Transfer Journal Entries to GL for Latin American AR and AP Imported from BI Publisher Description: Use this program to transfer to GL subledger journal entries generated by previous executions of the create accounting program Application: Latin America Localizations Source: Transfer Journal Entries to GL for Latin American AR and AP Short Name: JLARAPTR DB package: XLA_CREATE_ACCT_RPT_PVT BI Publisher &p_group_id_str &p_req_id :application_id :c_acct_prog_return_code :g_launch_balance_program :p_accounting_mode :p_accounting_mode_name :p_accounting_report_level :p_application_id :p_application_name :p_application_query :p_conc_request_id :p_create_accounting :p_create_accounting_flag :p_dummy :p_dummy_param_1 :p_dummy_param_2 :p_dummy_param_3 :p_end_date :p_entity_id :p_errors_only :p_errors_only_flag :p_event_filter :p_gl_batch_name :p_group_id_str :p_include_user_trx_id_flag :p_include_user_trx_identifiers :p_include_zero_amount_lines :p_include_zero_amt_lines :p_launch_bal_program :p_launch_balance_program :p_ledger_id :p_ledger_name :p_min_precision :p_post_in_gl :p_post_in_gl_flag :p_process_category_code :p_process_category_name :p_report_style :p_req_id :p_request_id :p_security_char_1 :p_security_char_2 :p_security_char_3 :p_security_int_1 :p_security_int_2 :p_security_int_3 :p_source_application_id :p_source_application_name :p_transfer_to_gl :p_transfer_to_gl_flag :p_trx_identifiers :p_trx_identifiers_1 :p_trx_identifiers_2 :p_trx_identifiers_3 :p_trx_identifiers_4 :p_trx_identifiers_5 :p_user_id :p_valuation_method_code :p_zero_amt_filter 1 -210 :p_application_id LOV Oracle XLA_SRS_SUBLEDGERS Y select application_id id, application_name value, null description from (select application_name,application_id from xla_subledgers_fvl union select application_name,application_id from fnd_application_vl where application_id=101) order by value,description SELECT APPLICATION_NAME FROM FND_APPLICATION_VL WHERE APPLICATION_ID = (SELECT DATA_GROUP_APPLICATION_ID FROM FND_RESPONSIBILITY WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')) PTB Aplicação ID da Aplicação US Application Application ID 2 -200 :p_source_application_id LOV Oracle XLA_SRS_SOURCE_APPLICATION Y select application_id id, application_name value, null description from fnd_application_vl fvl order by value,description SELECT APPLICATION_NAME FROM FND_APPLICATION_VL WHERE APPLICATION_ID = (SELECT DATA_GROUP_APPLICATION_ID FROM FND_RESPONSIBILITY WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')) PTB Aplicação de Origem Id da Aplicação de Origem US Source Application Source Application Id 3 -190 :p_dummy Char SELECT 'Y' FROM DUAL WHERE :$flex$.source_application:NULL IS NOT NULL OR :$flex$.application:NULL IS NOT NULL US XLA_SRS_NO_VALIDATION 4 -170 :p_dummy_param_1 Char SELECT 'Y' FROM DUAL WHERE :$flex$.create_accounting = 'Y' US XLA_SRS_NO_VALIDATION 5 -130 :p_dummy_param_3 Char SELECT 'Y' FROM DUAL WHERE :$flex$.transfer_to_general_ledger = 'Y' US XLA_SRS_NO_VALIDATION 6 -180 :p_create_accounting_flag LOV Oracle XLA_SRS_CREATE_ACCOUNTING_FLAG Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description SELECT MEANING FROM XLA_LOOKUPS WHERE LOOKUP_TYPE = 'XLA_YES_NO' AND LOOKUP_CODE = 'N' PTB Criar Contabilidade Criar Indicador Contábil US Create Accounting Create Accounting Flag 7 -160 :p_dummy_param_2 Char SELECT 'Y' FROM DUAL WHERE NVL(:$flex$.:NULL,'F') = 'F' US XLA_SRS_ACCOUNTING_MODE_DUMMY 8 -150 :p_report_style LOV Oracle XLA_SRS_REPORT_MODE_JL Y select xlk.lookup_code id, xlk.meaning value, null description from xla_lookups xlk,xla_subledger_options_v xso where xlk.lookup_type='XLA_ACCT_TRANSFER_MODE' and :$flex$.xla_srs_no_validation='Y' and xso.ledger_id=:$flex$.xla_srs_subledger_ledgers_jl and xso.application_id=(select data_group_application_id from fnd_responsibility where responsibility_id=fnd_global.resp_id) and decode(xso.summary_report_override_flag,'Y', xlk.lookup_code,xso.summary_report_flag) =xlk.lookup_code order by value,description SELECT MEANING FROM XLA_LOOKUPS XLK, XLA_SUBLEDGER_OPTIONS_V XSO WHERE XLK.LOOKUP_TYPE = 'XLA_ACCT_TRANSFER_MODE' AND XLK.LOOKUP_CODE = XSO.SUMMARY_REPORT_FLAG AND XSO.APPLICATION_ID = (SELECT DATA_GROUP_APPLICATION_ID FROM FND_RESPONSIBILITY WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')) AND XSO.LEDGER_ID = :$flex$.ledger Y PTB Relatório Relatório US Report Report 9 -140 :p_transfer_to_gl_flag LOV Oracle XLA_SRS_SUBMIT_TRANSFER_FLAG_JL Y select xlk.lookup_code id, xlk.meaning value, null description from xla_lookups xlk,xla_subledger_options_v xso where xlk.lookup_type='XLA_YES_NO' and :$flex$.xla_srs_accounting_mode_dummy='Y' and xso.ledger_id=:$flex$.xla_srs_subledger_ledgers_jl and xso.application_id=(select data_group_application_id from fnd_responsibility where responsibility_id=fnd_global.resp_id) and decode(xso.submit_transfer_override_flag,'Y', xlk.lookup_code,xso.submit_transfer_to_gl_flag) =xlk.lookup_code order by value,description SELECT MEANING FROM XLA_LOOKUPS XLK, XLA_SUBLEDGER_OPTIONS_V XSO WHERE XLK.LOOKUP_TYPE = 'XLA_YES_NO' AND XLK.LOOKUP_CODE = XSO.SUBMIT_TRANSFER_TO_GL_FLAG AND XSO.APPLICATION_ID = (SELECT DATA_GROUP_APPLICATION_ID FROM FND_RESPONSIBILITY WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')) AND XSO.LEDGER_ID = :$flex$.ledger Y PTB Transferência para o GL Transferir para Indicador de GL US Transfer to General Ledger Transfer to GL Flag 10 -120 :p_min_precision Number fnd_profile.value('CURRENCY:MIXED_PRECISION') PTB Precisão de Moeda Mista US Mixed Currency Precision 11 -110 :p_source_application_name Char SELECT :$flex$.source_application.VALUE FROM DUAL PTB Nome da Aplicação de Origem Nome da Aplicação de Origem US Source Application Name Source Application Name 12 -100 :p_application_name Char SELECT :$flex$.application.VALUE FROM DUAL PTB Nome da Aplicação Nome da Aplicação US Application Name Application Name 13 -90 :p_ledger_name Char SELECT :$flex$.ledger.VALUE FROM DUAL PTB Nome do Razão Nome do Razão US Ledger Name Ledger Name 14 -80 :p_process_category_name Char SELECT :$flex$.ledger.VALUE FROM DUAL PTB Nome da Categoria do Processo Nome da Categoria do Processo US Process Category Name Process Category Name 15 -70 :p_create_accounting Char SELECT :$flex$.create_accounting.VALUE FROM DUAL PTB Criar Contabilidade 2 Criar Contabilidade US Create Accounting 2 Create Accounting 16 -60 :p_accounting_mode_name Char SELECT :$flex$.mode.VALUE FROM DUAL PTB Nome do Modo Contábil Nome do Modo Contábil US Accounting Mode Name Accounting Mode Name 17 -50 :p_errors_only Char SELECT :$flex$.errors_only.VALUE FROM DUAL PTB Somente Erros Somente Erros US Errors Only Errors Only 18 -40 :p_accounting_report_level Char SELECT :$flex$.report.VALUE FROM DUAL PTB Nível do Relatório Nível do Relatório US Report Level Report Level 19 -30 :p_transfer_to_gl Char SELECT :$flex$.transfer_to_general_ledger.VALUE FROM DUAL PTB Transferir para o GL Transferir para o GL US Transfer To GL Transfer To GL 20 -20 :p_post_in_gl Char SELECT :$flex$.post_in_general_ledger.VALUE FROM DUAL PTB Contabilizar no GL Contabilizar no GL US Post in GL Post in GL 21 -10 :debugflag Char SELECT DECODE ( FND_PROFILE.VALUE('AFLOG_ENABLED') || FND_PROFILE.VALUE('AFLOG_LEVEL') , 'Y1', 'Y', 'N' ) FROM DUAL PTB Ativar Log de Depuração Indicador para ativação do Log de Depuração US Enable Debug Log Flag to enable Debug Log 22 10 :p_ledger_id LOV Oracle XLA_SRS_SUBLEDGER_LEDGERS_JL Y select xso.ledger_id id, xso.name value, null description from xla_subledger_options_v xso where xso.application_id=(select data_group_application_id from fnd_responsibility where responsibility_id=fnd_global.resp_id) and :$flex$.xla_srs_no_validation='Y' and xso.capture_event_flag='Y' and xso.enabled_flag='Y' and xso.sla_accounting_method_code is not null and ( (nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='N') or ( nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='Y' and exists (select 1 from gl_access_sets gas, gl_access_set_assignments asa where gas.access_set_id=asa.access_set_id and gas.chart_of_accounts_id=xso.chart_of_accounts_id and asa.ledger_id=xso.ledger_id and ( gas.access_set_id=nvl(fnd_profile.value('GL_ACCESS_SET_ID'),'-1') or gas.access_set_id=nvl(fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID'),'-1') ) ) ) ) order by value,description Y PTB Razão ID do Razão US Ledger Ledger ID 23 20 :p_process_category_code LOV Oracle XLA_SRS_PROCESS_CATEGORY_JL Y select event_class_group_code id, name value, null description from xla_event_class_grps_vl where application_id=(select data_group_application_id from fnd_responsibility where responsibility_id=fnd_global.resp_id) and name<>'All' order by value,description PTB Categoria do Processo Código da Categoria do Processo US Process Category Process Category Code 24 30 :p_end_date Date Y PTB Data Final Data Final US End Date End Date 25 40 :p_post_in_gl_flag LOV Oracle XLA_SRS_SUBMIT_GLPOST_FLAG_JL Y select xlk.lookup_code id, xlk.meaning value, null description from xla_lookups xlk,xla_subledger_options_v xso where xlk.lookup_type='XLA_YES_NO' and :$flex$.xla_srs_no_validation='Y' and xso.ledger_id=:$flex$.xla_srs_subledger_ledgers_jl and xso.application_id=(select data_group_application_id from fnd_responsibility where responsibility_id=fnd_global.resp_id) and decode(xso.submit_gl_post_override_flag,'Y', xlk.lookup_code,xso.submit_gl_post_flag) =xlk.lookup_code order by value,description SELECT MEANING FROM XLA_LOOKUPS XLK, XLA_SUBLEDGER_OPTIONS_V XSO WHERE XLK.LOOKUP_TYPE = 'XLA_YES_NO' AND XLK.LOOKUP_CODE = XSO.SUBMIT_GL_POST_FLAG AND XSO.APPLICATION_ID = (SELECT DATA_GROUP_APPLICATION_ID FROM FND_RESPONSIBILITY WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')) AND XSO.LEDGER_ID = :$flex$.ledger Y PTB Contabilizar no General Ledger Indicador Contabilizar para o GL US Post in General Ledger Post to GL Flag 26 50 :p_gl_batch_name Char PTB Nome do Lote do General Ledger Nome do Lote do General Ledger US General Ledger Batch Name General Ledger Batch Name