ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470B851A9E05362FB09050512Y SELECT TABLE1.APPLICATION_ID APPLICATION_ID ,TABLE1.EVENT_CLASS_CODE EVENT_CLASS_CODE ,TABLE1.EVENT_CLASS_NAME EVENT_CLASS_NAME ,TABLE1.EVENT_TYPE_NAME EVENT_TYPE_NAME ,TABLE1.EVENT_ID EVENT_ID ,TABLE1.EVENT_STATUS_CODE EVENT_STATUS_CODE ,TABLE1.EVENT_STATUS EVENT_STATUS ,TABLE1.EVENT_NUMBER EVENT_NUMBER ,TABLE1.EVENT_DATE EVENT_DATE ,TABLE1.ENTITY_ID ENTITY_ID ,TABLE1.LEDGER_ID LEDGER_ID ,TABLE1.LEDGER_NAME LEDGER_NAME ,TABLE1.LEDGER_CURRENCY LEDGER_CURRENCY ,TABLE1.COA_ID COA_ID ,TABLE1.PAD_NAME PAD_NAME ,TABLE1.PAD_VERSION PAD_VERSION ,TABLE1.AE_HEADER_ID AE_HEADER_ID ,TABLE1.BALANCE_TYPE BALANCE_TYPE ,TABLE1.BALANCE_TYPE_MEANING BALANCE_TYPE_MEANING ,TABLE1.GL_DATE GL_DATE ,TABLE1.AE_DESCRIPTION AE_DESCRIPTION ,TABLE1.AE_STATUS_CODE AE_STATUS_CODE ,TABLE1.AE_STATUS_MEANING AE_STATUS_MEANING ,TABLE1.DISPLAYED_LINE_NUM DISPLAYED_LINE_NUM ,TABLE1.AE_LINE_NUM AE_LINE_NUM ,TABLE1.ACCOUNT_CCID ACCOUNT_CCID ,TABLE1.ENTERED_CURRENCY ENTERED_CURRENCY ,TABLE1.ENTERED_DR ENTERED_DR ,TABLE1.ENTERED_CR ENTERED_CR ,TABLE1.ACCOUNTED_DR ACCOUNTED_DR ,TABLE1.ACCOUNTED_CR ACCOUNTED_CR ,TABLE1.ACCOUNTING_CLASS ACCOUNTING_CLASS ,TABLE1.ERROR_AE_LINE_NUM ERROR_AE_LINE_NUM ,TABLE1.MESSAGE_NUMBER MESSAGE_NUMBER ,TABLE1.ENCODED_MSG ENCODED_MSG ,TABLE1.ACCOUNT_SEGMENTS ACCOUNT_SEGMENTS ,substr(USERIDS,1,instr(USERIDS,'|',1,1)-1) USER_TRX_IDENTIFIER_NAME_1 ,substr(USERIDS,instr(USERIDS,'|',1,1)+1,(instr(USERIDS,'|',1,2)-1-instr(USERIDS,'|',1,1))) USER_TRX_IDENTIFIER_VALUE_1 ,substr(USERIDS,instr(USERIDS,'|',1,2)+1,(instr(USERIDS,'|',1,3)-1-instr(USERIDS,'|',1,2))) USER_TRX_IDENTIFIER_NAME_2 ,substr(USERIDS,instr(USERIDS,'|',1,3)+1,(instr(USERIDS,'|',1,4)-1-instr(USERIDS,'|',1,3))) USER_TRX_IDENTIFIER_VALUE_2 ,substr(USERIDS,instr(USERIDS,'|',1,4)+1,(instr(USERIDS,'|',1,5)-1-instr(USERIDS,'|',1,4))) USER_TRX_IDENTIFIER_NAME_3 ,substr(USERIDS,instr(USERIDS,'|',1,5)+1,(instr(USERIDS,'|',1,6)-1-instr(USERIDS,'|',1,5))) USER_TRX_IDENTIFIER_VALUE_3 ,substr(USERIDS,instr(USERIDS,'|',1,6)+1,(instr(USERIDS,'|',1,7)-1-instr(USERIDS,'|',1,6))) USER_TRX_IDENTIFIER_NAME_4 ,substr(USERIDS,instr(USERIDS,'|',1,7)+1,(instr(USERIDS,'|',1,8)-1-instr(USERIDS,'|',1,7))) USER_TRX_IDENTIFIER_VALUE_4 ,substr(USERIDS,instr(USERIDS,'|',1,8)+1,(instr(USERIDS,'|',1,9)-1-instr(USERIDS,'|',1,8))) USER_TRX_IDENTIFIER_NAME_5 ,substr(USERIDS,instr(USERIDS,'|',1,9)+1,(instr(USERIDS,'|',1,10)-1-instr(USERIDS,'|',1,9))) USER_TRX_IDENTIFIER_VALUE_5 ,substr(USERIDS,instr(USERIDS,'|',1,10)+1,(instr(USERIDS,'|',1,11)-1-instr(USERIDS,'|',1,10))) USER_TRX_IDENTIFIER_NAME_6 ,substr(USERIDS,instr(USERIDS,'|',1,11)+1,(instr(USERIDS,'|',1,12)-1-instr(USERIDS,'|',1,11))) USER_TRX_IDENTIFIER_VALUE_6 ,substr(USERIDS,instr(USERIDS,'|',1,12)+1,(instr(USERIDS,'|',1,13)-1-instr(USERIDS,'|',1,12))) USER_TRX_IDENTIFIER_NAME_7 ,substr(USERIDS,instr(USERIDS,'|',1,13)+1,(instr(USERIDS,'|',1,14)-1-instr(USERIDS,'|',1,13))) USER_TRX_IDENTIFIER_VALUE_7 ,substr(USERIDS,instr(USERIDS,'|',1,14)+1,(instr(USERIDS,'|',1,15)-1-instr(USERIDS,'|',1,14))) USER_TRX_IDENTIFIER_NAME_8 ,substr(USERIDS,instr(USERIDS,'|',1,15)+1,(instr(USERIDS,'|',1,16)-1-instr(USERIDS,'|',1,15))) USER_TRX_IDENTIFIER_VALUE_8 ,substr(USERIDS,instr(USERIDS,'|',1,16)+1,(instr(USERIDS,'|',1,17)-1-instr(USERIDS,'|',1,16))) USER_TRX_IDENTIFIER_NAME_9 ,substr(USERIDS,instr(USERIDS,'|',1,17)+1,(instr(USERIDS,'|',1,18)-1-instr(USERIDS,'|',1,17))) USER_TRX_IDENTIFIER_VALUE_9 ,substr(USERIDS,instr(USERIDS,'|',1,18)+1,(instr(USERIDS,'|',1,19)-1-instr(USERIDS,'|',1,18))) USER_TRX_IDENTIFIER_NAME_10 ,substr(USERIDS,instr(USERIDS,'|',1,19)+1,(length(USERIDS)-instr(USERIDS,'|',1,19))) USER_TRX_IDENTIFIER_VALUE_10 FROM ( SELECT EVT.APPLICATION_ID APPLICATION_ID ,XET.EVENT_CLASS_CODE EVENT_CLASS_CODE ,XEC.NAME EVENT_CLASS_NAME ,XET.NAME EVENT_TYPE_NAME ,EVT.EVENT_ID EVENT_ID ,EVT.PROCESS_STATUS_CODE EVENT_STATUS_CODE ,XL3.MEANING EVENT_STATUS ,EVT.EVENT_NUMBER EVENT_NUMBER ,TO_CHAR(EVT.EVENT_DATE,'YYYY-MM-DD') EVENT_DATE ,EVT.ENTITY_ID ENTITY_ID ,XGL.LEDGER_ID LEDGER_ID ,XGL.NAME LEDGER_NAME ,XGL.CURRENCY_CODE LEDGER_CURRENCY ,XGL.CHART_OF_ACCOUNTS_ID COA_ID ,XPR.NAME PAD_NAME ,XPR.PRODUCT_RULE_VERSION PAD_VERSION ,AEH.AE_HEADER_ID AE_HEADER_ID ,AEH.BALANCE_TYPE_CODE BALANCE_TYPE ,XLK.MEANING BALANCE_TYPE_MEANING ,TO_CHAR(AEH.ACCOUNTING_DATE ,'YYYY-MM-DD') GL_DATE ,AEH.DESCRIPTION AE_DESCRIPTION ,AEH.ACCOUNTING_ENTRY_STATUS_CODE AE_STATUS_CODE ,XL1.MEANING AE_STATUS_MEANING ,AEL.DISPLAYED_LINE_NUMBER DISPLAYED_LINE_NUM ,AEL.AE_LINE_NUM AE_LINE_NUM ,AEL.CODE_COMBINATION_ID ACCOUNT_CCID ,AEL.CURRENCY_CODE ENTERED_CURRENCY ,AEL.ENTERED_DR ENTERED_DR ,AEL.ENTERED_CR ENTERED_CR ,AEL.ACCOUNTED_DR ACCOUNTED_DR ,AEL.ACCOUNTED_CR ACCOUNTED_CR ,XL2.MEANING ACCOUNTING_CLASS ,NULL ERROR_AE_LINE_NUM ,NULL MESSAGE_NUMBER ,NULL ENCODED_MSG ,FND_FLEX_EXT.GET_SEGS ('SQLGL' ,'GL#' ,XGL.CHART_OF_ACCOUNTS_ID ,AEL.CODE_COMBINATION_ID) ACCOUNT_SEGMENTS &P_TRX_IDENTIFIERS_1 &P_TRX_IDENTIFIERS_2 &P_TRX_IDENTIFIERS_3 &P_TRX_IDENTIFIERS_4 &P_TRX_IDENTIFIERS_5 FROM XLA_EVENTS EVT ,XLA_TRANSACTION_ENTITIES ENT ,XLA_EVENT_TYPES_VL XET ,XLA_EVENT_CLASSES_TL XEC ,XLA_AE_HEADERS AEH ,XLA_AE_LINES AEL ,XLA_GL_LEDGERS_V XGL ,XLA_PRODUCT_RULES_VL XPR ,XLA_LOOKUPS XLK ,XLA_LOOKUPS XL1 ,XLA_LOOKUPS XL2 ,XLA_LOOKUPS XL3 WHERE EVT.APPLICATION_ID = :APPLICATION_ID AND EVT.REQUEST_ID = :REQUEST_ID AND ENT.APPLICATION_ID = EVT.APPLICATION_ID AND ENT.ENTITY_ID = EVT.ENTITY_ID AND XET.APPLICATION_ID = ENT.APPLICATION_ID AND XET.ENTITY_CODE = ENT.ENTITY_CODE AND XET.EVENT_TYPE_CODE = EVT.EVENT_TYPE_CODE AND XEC.APPLICATION_ID = XET.APPLICATION_ID AND XEC.EVENT_CLASS_CODE = XET.EVENT_CLASS_CODE AND XEC.LANGUAGE = USERENV('LANG') AND AEH.APPLICATION_ID = EVT.APPLICATION_ID AND AEH.EVENT_ID = EVT.EVENT_ID AND AEH.ACCOUNTING_ENTRY_STATUS_CODE <> 'N' AND AEL.APPLICATION_ID = AEH.APPLICATION_ID AND AEL.AE_HEADER_ID = AEH.AE_HEADER_ID AND XGL.LEDGER_ID = AEH.LEDGER_ID AND XPR.APPLICATION_ID = AEH.APPLICATION_ID AND XPR.PRODUCT_RULE_TYPE_CODE = AEH.PRODUCT_RULE_TYPE_CODE AND XPR.PRODUCT_RULE_CODE = AEH.PRODUCT_RULE_CODE AND XPR.AMB_CONTEXT_CODE = AEH.AMB_CONTEXT_CODE AND XLK.LOOKUP_TYPE = 'XLA_BALANCE_TYPE' AND XLK.LOOKUP_CODE = AEH.BALANCE_TYPE_CODE AND XL1.LOOKUP_TYPE = 'XLA_ACCOUNTING_ENTRY_STATUS' AND XL1.LOOKUP_CODE = AEH.ACCOUNTING_ENTRY_STATUS_CODE AND XL2.LOOKUP_TYPE = 'XLA_ACCOUNTING_CLASS' AND XL2.LOOKUP_CODE = AEL.ACCOUNTING_CLASS_CODE AND XL3.LOOKUP_TYPE = 'XLA_EVENT_PROCESS_STATUS' AND XL3.LOOKUP_CODE = EVT.PROCESS_STATUS_CODE &P_EVENT_FILTER &P_ZERO_AMT_FILTER AND :P_REPORT_STYLE <> 'N' UNION SELECT EVT.APPLICATION_ID APPLICATION_ID ,XET.EVENT_CLASS_CODE EVENT_CLASS_CODE ,XEC.NAME EVENT_CLASS_NAME ,XET.NAME EVENT_TYPE_NAME ,EVT.EVENT_ID EVENT_ID ,EVT.PROCESS_STATUS_CODE EVENT_STATUS_CODE ,XLK.MEANING EVENT_STATUS ,EVT.EVENT_NUMBER EVENT_NUMBER ,TO_CHAR(EVT.EVENT_DATE,'YYYY-MM-DD') EVENT_DATE ,EVT.ENTITY_ID ENTITY_ID ,XGL.LEDGER_ID LEDGER_ID ,XGL.NAME LEDGER_NAME ,XGL.CURRENCY_CODE LEDGER_CURRENCY ,XGL.CHART_OF_ACCOUNTS_ID COA_ID ,NULL PAD_NAME ,NULL PAD_VERSION ,ERR.AE_HEADER_ID AE_HEADER_ID ,NULL BALANCE_TYPE ,NULL BALANCE_TYPE_MEANING ,NULL GL_DATE ,NULL AE_DESCRIPTION ,NULL AE_STATUS_CODE ,NULL AE_STATUS_MEANING ,ERR.AE_LINE_NUM DISPLAYED_LINE_NUM ,ERR.AE_LINE_NUM AE_LINE_NUM ,NULL ACCOUNT_CCID ,NULL ENTERED_CURRENCY ,NULL ENTERED_DR ,NULL ENTERED_CR ,NULL ACCOUNTED_DR ,NULL ACCOUNTED_CR ,NULL ACCOUNTING_CLASS ,ERR.AE_LINE_NUM ERROR_AE_LINE_NUM ,ERR.MESSAGE_NUMBER MESSAGE_NUMBER ,ERR.ENCODED_MSG ENCODED_MSG ,NULL ACCOUNT_SEGMENTS &P_TRX_IDENTIFIERS_1 &P_TRX_IDENTIFIERS_2 &P_TRX_IDENTIFIERS_3 &P_TRX_IDENTIFIERS_4 &P_TRX_IDENTIFIERS_5 FROM XLA_EVENTS EVT ,XLA_TRANSACTION_ENTITIES ENT ,XLA_EVENT_TYPES_VL XET ,XLA_EVENT_CLASSES_TL XEC ,XLA_ACCOUNTING_ERRORS ERR ,XLA_GL_LEDGERS_V XGL ,XLA_LOOKUPS XLK WHERE EVT.APPLICATION_ID = :APPLICATION_ID AND EVT.REQUEST_ID = :REQUEST_ID AND EVT.PROCESS_STATUS_CODE IN ('I','E','R') AND XLK.LOOKUP_TYPE = 'XLA_EVENT_PROCESS_STATUS' AND XLK.LOOKUP_CODE = EVT.PROCESS_STATUS_CODE AND ENT.APPLICATION_ID = EVT.APPLICATION_ID AND ENT.ENTITY_ID = EVT.ENTITY_ID AND XET.APPLICATION_ID = ENT.APPLICATION_ID AND XET.ENTITY_CODE = ENT.ENTITY_CODE AND XET.EVENT_TYPE_CODE = EVT.EVENT_TYPE_CODE AND XEC.APPLICATION_ID = XET.APPLICATION_ID AND XEC.EVENT_CLASS_CODE = XET.EVENT_CLASS_CODE AND XEC.LANGUAGE = USERENV('LANG') AND ERR.EVENT_ID = EVT.EVENT_ID AND XGL.LEDGER_ID(+) = ERR.LEDGER_ID AND :P_REPORT_STYLE <> 'N' )TABLE1 JL JLFAACCP PTB JL Criar Contabilidade para FA da América Latina Imported from BI Publisher Application: Localizações da América Latina Source: Criar Contabilidade para FA da América Latina Short Name: JLFAACCP DB package: XLA_CREATE_ACCT_RPT_PVT US JL Create Accounting for Latin American FA Imported from BI Publisher Application: Latin America Localizations Source: Create Accounting for Latin American FA Short Name: JLFAACCP DB package: XLA_CREATE_ACCT_RPT_PVT BI Publisher &p_event_filter &p_trx_identifiers_1 &p_trx_identifiers_2 &p_trx_identifiers_3 &p_trx_identifiers_4 &p_trx_identifiers_5 &p_zero_amt_filter :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 :request_id 1 -220 :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 Aplicação de Origem US Source Application Source Application 2 -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 Aplicação US Application Application 3 -200 :p_dummy Char SELECT 'Y' FROM DUAL WHERE :$flex$.source_application:NULL IS NOT NULL OR :$flex$.application:NULL IS NOT NULL PTB XLA_SRS_NO_VALIDATION Parâmetro Fictício 0 US XLA_SRS_NO_VALIDATION Dummy Parameter 0 4 -170 :p_dummy_param_1 Char SELECT 'Y' FROM DUAL WHERE :$flex$.create_accounting = 'Y' PTB XLA_SRS_NO_VALIDATION Parâmetro Fictício 1 US XLA_SRS_NO_VALIDATION Dummy Parameter 1 5 -150 :p_dummy_param_3 Char SELECT 'Y' FROM DUAL WHERE :$flex$.transfer_to_general_ledger = 'Y' PTB XLA_SRS_NO_VALIDATION Parâmetro Fictício 3 US XLA_SRS_NO_VALIDATION Dummy Parameter 3 6 -190 :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 SELECT NAME FROM GL_LEDGERS L, FA_BOOK_CONTROLS BC WHERE l.ledger_id = bc.set_of_books_id and bc.BOOK_TYPE_CODE = :$flex$.book_type_code PTB XLA_SRS_SUBLEDGER_LEDGERS_JL ID do Razão US XLA_SRS_SUBLEDGER_LEDGERS_JL Ledger ID 7 -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 = 'Y' PTB Criar Contabilidade Criar Indicador Contábil US Create Accounting Create Accounting Flag 8 -160 :p_dummy_param_2 Char SELECT 'Y' FROM DUAL WHERE NVL(:$flex$.:NULL,'F') = 'F' PTB XLA_SRS_ACCOUNTING_MODE_DUMMY Parâmetro Fictício 2 US XLA_SRS_ACCOUNTING_MODE_DUMMY Dummy Parameter 2 9 -140 :p_min_precision Number fnd_profile.value('CURRENCY:MIXED_PRECISION') PTB Precisão de Moeda Mista Precisão de Moeda Mista US Mixed Currency Precision Mixed Currency Precision 10 -130 :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 11 -120 :p_application_name Char SELECT :$flex$.application.VALUE FROM DUAL PTB Nome da Aplicação Nome da Aplicação US Application Name Application Name 12 -110 :p_ledger_name Char SELECT :$FLEX$.XLA_SRS_SUBLEDGER_LEDGERS_JL.VALUE FROM DUAL PTB Nome do Razão Nome do Razão US Ledger Name Ledger Name 13 -100 :p_process_category_name Char SELECT :$flex$.process_category.VALUE FROM DUAL PTB Nome da Categoria do Processo Nome da Categoria do Processo US Process Category Name Process Category Name 14 -90 :p_create_accounting Char SELECT :$flex$.create_accounting.VALUE FROM DUAL PTB Criar Contabilidade 2 Criar Contabilidade US Create Accounting 2 Create Accounting 15 -80 :p_accounting_mode_name Char SELECT :$flex$.accounting_mode.VALUE FROM DUAL PTB Nome do Modo Contábil Nome do Modo Contábil US Accounting Mode Name Accounting Mode Name 16 -70 :p_errors_only Char SELECT :$flex$.errors_only.VALUE FROM DUAL Y PTB Somente Erros 2 Somente Erros US Errors Only 2 Errors Only 17 -60 :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 18 -50 :p_transfer_to_gl Char SELECT :$flex$.transfer_to_general_ledger.VALUE FROM DUAL PTB Transferir para GL Transferir para GL US Transfer to GL Transfer to GL 19 -40 :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 20 -30 :p_include_zero_amt_lines Char SELECT :$flex$.include_zero_amt_lines_flag.VALUE FROM DUAL PTB Incluir Linhas com Quantia Zero Incluir Linhas com Quantia Zero US Include Zero Amount Lines Include Zero Amount Lines 21 -20 :p_include_user_trx_identifiers Char SELECT :$flex$.include_user_transaction_identifiers.VALUE FROM DUAL PTB P_INCLUDE_USER_TRX_IDENTIFIERS Valor traduzido para o indicador 'Incluir Identificadores de Transação do Usuário' US P_INCLUDE_USER_TRX_IDENTIFIERS Translated value for 'Include User Transaction Identifiers' flag 22 -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 ativar Log de depuração US Enable Debug Log Flag to enable Debug log 23 10 :p_valuation_method_code LOV Oracle FA_BOOK_TYPE Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec order by book_type_code PTB Código do Tipo de Livro Código do Tipo de Livro US Book Type Code Book Type Code 24 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 Categoria do Processo US Process Category Process Category 25 30 :p_end_date Date sysdate Y PTB Data Final Data Final US End Date End Date 26 40 :p_accounting_mode LOV Oracle XLA_SRS_ACCOUNTING_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_ACCOUNTING_ENTRY_STATUS' and xlk.lookup_code in ('D','F') 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.accounting_mode_override_flag,'Y', xlk.lookup_code,xso.accounting_mode_code) =xlk.lookup_code order by value,description SELECT MEANING FROM XLA_LOOKUPS XLK, XLA_SUBLEDGER_OPTIONS_V XSO WHERE XLK.LOOKUP_TYPE = 'XLA_ACCOUNTING_ENTRY_STATUS' AND XLK.LOOKUP_CODE = XSO.ACCOUNTING_MODE_CODE 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$.XLA_SRS_SUBLEDGER_LEDGERS_JL Y PTB Modo Contábil Modo Contábil US Accounting Mode Accounting Mode 27 50 :p_errors_only_flag LOV Oracle XLA_SRS_YES_NO_DEPENDENT Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' and :$flex$.xla_srs_no_validation='Y' order by value,description SELECT MEANING FROM XLA_LOOKUPS WHERE LOOKUP_TYPE = 'XLA_YES_NO' AND LOOKUP_CODE = 'N' Y PTB Somente Erros Indicador de Somente Erros US Errors Only Errors Only Flag 28 60 :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$.XLA_SRS_SUBLEDGER_LEDGERS_JL PTB Relatório Relatório US Report Report 29 70 :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$.XLA_SRS_SUBLEDGER_LEDGERS_JL Y PTB Transferência para o GL Transferir para Indicador de GL US Transfer to General Ledger Transfer to GL Flag 30 80 :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$.XLA_SRS_SUBLEDGER_LEDGERS_JL PTB Contabilizar no General Ledger Indicador Contabilizar para o GL US Post in General Ledger Post to GL Flag 31 90 :p_gl_batch_name Char PTB Nome do Lote do General Ledger Nome do Lote GL US General Ledger Batch Name GL Batch Name 32 100 :p_include_zero_amount_lines LOV Oracle XLA_SRS_YES_NO 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 Incluir Indicador de Linhas com Quantia Zero Incluir Indicador de Linhas com Quantia Zero US Include Zero Amt lines Flag Include Zero Amt lines Flag 33 110 :p_include_user_trx_id_flag LOV Oracle XLA_SRS_YES_NO 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' Y PTB Incluir Identificadores de Transação do Usuário Indicador Incluir Identificadores de Transação do Usuário US Include User Transaction Identifiers Include User Transaction Identifiers flag