ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470BA51A9E05362FB09050512Y Select to_char(jml.journal_date,'YYYY-MM-DD') journal_date, substr(gl_je_name,1,(50 - (length(to_char(je_header_id))+1))) || ' ' || to_char(je_header_id) journal_name, substr(jml.line_description,1,200) line_description, trim(TO_CHAR(ROUND(NVL(jml.ACCOUNTED_DR,0), :G_PRECISION),'9999999999999999999990.00')) accounted_dr, trim(TO_CHAR(ROUND(NVL(jml.ACCOUNTED_CR,0), :G_PRECISION),'9999999999999999999990.00')) accounted_cr, jma.natural_account || ' ' || jma.subaccount account, substr(jma.natural_account_desc || ' ' || jma.subaccount_desc, 1 ,100) description, trim(TO_CHAR(ROUND(NVL(jma.BEGIN_BALANCE,0), :G_PRECISION),'9999999999999999999990.00')) begin_balance, trim(TO_CHAR(ROUND(NVL(jma.END_BALANCE,0), :G_PRECISION),'9999999999999999999990.00')) end_balance From jl_mx_je_lines_t jml, jl_mx_gl_accounts_t jma Where jml.request_id = :g_con_request_id and jma.config_id = :P_CONFIG_ID and decode(jma.company_bsv,'T','1', jma.company_bsv) = decode(jma.company_bsv,'T','1', jml.addit_info_1) and jma.natural_account = jml.addit_info_2 And nvl(Decode(Jma.Subaccount,'T','1', Jma.Subaccount),'1') = nvl(Decode(Jma.Subaccount,'T','1', Jml.Subaccount),'1') -- and Jma.Sat_account is not null order by jma.natural_account,jml.journal_date, jml.gl_je_name, jml.je_header_id JL JLMXAAUX_XMLP PTB JL Relatório Auxiliar de Contas Mexicano - Arquivo XML Imported from BI Publisher Application: Localizações da América Latina Source: Relatório Auxiliar de Contas Mexicano - Arquivo XML Short Name: JLMXAAUX_XMLP DB package: JL_MX_JOURNAL_ENTRIES_PKG US JL Mexican Accounts Auxiliary Report - XML File Imported from BI Publisher Application: Latin America Localizations Source: Mexican Accounts Auxiliary Report - XML File Short Name: JLMXAAUX_XMLP DB package: JL_MX_JOURNAL_ENTRIES_PKG BI Publisher :g_con_request_id :g_precision :p_account_flexfield_from :p_account_flexfield_to :p_audit_process_num :p_audit_req_num :p_certificate :p_certificate_num :p_coa_id :p_commercial_query :p_config_id :p_entered_currency :p_fetch_from_gl :p_gl_col_1 :p_gl_col_2 :p_gl_columns :p_gl_date_from :p_gl_date_to :p_gl_from :p_gl_join :p_gl_legal_ent_col :p_gl_legal_ent_from :p_gl_legal_ent_join :p_gl_party_details :p_gl_qualifier_segment :p_gl_seg_desc_from :p_gl_seg_desc_join :p_gl_view :p_gl_where :p_groupby_clause :p_incl_exp_uuid :p_include_le_info_flag :p_include_legal_entity_info :p_include_zero_amount_flag :p_include_zero_amount_lines :p_je_source :p_je_source_name :p_je_status :p_je_status_code :p_le_col :p_le_from :p_le_join :p_ledger :p_ledger_id :p_legal_entity :p_legal_entity_id :p_long_report :p_main_col_end :p_main_col_start :p_order_by :p_order_by_clause :p_orderby_clause :p_other_from :p_other_join :p_other_param_filter :p_other_sel :p_other_union :p_party_details :p_party_details_col :p_party_from :p_party_join :p_party_type :p_party_type_code :p_period_from :p_period_to :p_period_type :p_posting_status :p_posting_status_code :p_req_type_dummy :p_req_type_dummy1 :p_request_type :p_rpt_version :p_seal :p_segment_col :p_sla_col_1 :p_sla_col_2 :p_sla_col_3 :p_sla_from :p_sla_join :p_sla_legal_ent_col :p_sla_legal_ent_from :p_sla_legal_ent_join :p_sla_qualifier_segment :p_sla_seg_desc_from :p_sla_seg_desc_join :p_sub_acct_cols :p_sub_acct_seg :p_trx_legal_entity :p_trx_legal_entity_id :p_union_all :p_vat_registration_query 1 -130 :p_ledger_id LOV Oracle JGSLA_JELINES_LEDGERS Y select ledger_id id, name value, description description from gl_ledgers a where a.object_type_code='L' and ( nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='N' or exists (select 1 from gl_access_set_ledgers b where b.ledger_id=a.ledger_id and b.access_set_id in (decode (fnd_global.resp_appl_id ,101 ,null ,decode (fnd_profile.value('XLA_USE_LEDGER_SECURITY') ,'Y' ,fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID') ,null ) ) ,decode (fnd_global.resp_appl_id ,101 ,fnd_profile.value('GL_ACCESS_SET_ID') ,decode (fnd_profile.value('XLA_USE_LEDGER_SECURITY') ,'Y' ,fnd_profile.value('GL_ACCESS_SET_ID') ,b.access_set_id) ) ) ) ) order by value,description Select gl.name From JL_MX_GL_CONFIGS jm, GL_LEDGERS gl Where jm.CONFIG_ID = :$flex$.configuration_name and gl.ledger_id = jm.ledger_id Y PTB JGSLA_JELINES_LEDGERS Razão US JGSLA_JELINES_LEDGERS Ledger 2 -120 :p_ledger Char SELECT NAME FROM GL_LEDGERS WHERE LEDGER_ID = :$FLEX$.JGSLA_JELINES_LEDGERS PTB Nome do Razão Nome do Razão US Ledger Name Ledger Name 3 -110 :p_legal_entity_id LOV Oracle JGSLA_LEGAL_ENTITIES Y select gle.legal_entity_id id, xfi.name value, null description from gl_ledger_le_v gle,xle_firstparty_information_v xfi where gle.ledger_id=:$flex$.jgsla_jelines_ledgers and gle.legal_entity_id=xfi.legal_entity_id order by xfi.name Select xle.name FROM JL_MX_GL_CONFIGS jm, XLE_FIRSTPARTY_INFORMATION_V xle Where CONFIG_ID = :$flex$.configuration_name and xle.legal_entity_id = jm.legal_entity_id Y PTB Pessoa Jurídica Pessoa Jurídica US Legal Entity Legal Entity 4 -100 :p_legal_entity Char SELECT NAME FROM XLE_FIRSTPARTY_INFORMATION_V WHERE LEGAL_ENTITY_ID = :$flex$.legal_entity PTB Nome da Pessoa Jurídica Nome da Pessoa Jurídica US Legal Entity Name Legal Entity Name 5 -90 :p_je_source_name Char SELECT :$flex$.journal_entry_source.VALUE FROM DUAL PTB Nome de Origem do Lançamento Nome de Origem do Lançamento US Journal Entry Source Name Journal Entry Source Name 6 -80 :p_coa_id LOV Oracle JGSLA_CHART_OF_ACCOUNTS Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from gl_ledgers where ledger_id=:$flex$.jgsla_jelines_ledgers order by value,description Select map.from_coa_id From jl_mx_gl_configs jmco, gl_coa_mappings map Where jmco.config_id = :$flex$.configuration_name and map.coa_mapping_id = jmco.coa_mapping_id PTB JGSLA_CHART_OF_ACCOUNTS ID do Plano de Contas US JGSLA_CHART_OF_ACCOUNTS Chart of Accounts ID 7 -70 :p_sub_acct_seg LOV Oracle JLMX_SUB_ACCT_SEGMENT Y select segs.application_column_name id, segs.segment_name value, null description from fnd_id_flex_segments segs where segs.id_flex_num=:$flex$.jgsla_chart_of_accounts and segs.application_id=101 and segs.id_flex_code='GL#' and segs.application_column_name not in (select satt.application_column_name from fnd_segment_attribute_values satt where satt.id_flex_code=segs.id_flex_code and attribute_value='Y' and satt.segment_attribute_type in ('GL_ACCOUNT','GL_BALANCING') and satt.application_id=segs.application_id and satt.id_flex_num=segs.id_flex_num) order by value,description Select segs.segment_name From jl_mx_gl_configs jmco, gl_coa_mappings map, fnd_id_flex_segments segs Where jmco.config_id = :$flex$.configuration_name and map.coa_mapping_id = jmco.coa_mapping_id and segs.id_flex_num = map.from_coa_id and segs.application_id = 101 and segs.id_flex_code = 'GL#' and segs.segment_num = jmco.subaccount_seg_num PTB Nome do Segmento da Subconta Nome do Segmento da Subconta US Subaccount Segment Name Subaccount Segment Name 8 -60 :p_period_to LOV Oracle JGSLA_JELINES_PERIOD_TO_ADJ Y select period_name id, period_name value, null description from gl_ledgers gl,gl_periods glp where ((nvl(:$flex$.xla_srs_yes_no,'N')='N' and glp.adjustment_period_flag='N') or (nvl(:$flex$.xla_srs_yes_no,'N')='Y')) and gl.ledger_id=:$flex$.jgsla_jelines_ledgers and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and glp.period_year= (select glp2.period_year from gl_periods glp2 where glp2.period_set_name=glp.period_set_name and glp2.period_type=glp.period_type and glp2.period_name= :$flex$.jgsla_jelines_period_from_adj ) and glp.period_num>= (select glp2.period_num from gl_periods glp2 where glp2.period_set_name=glp.period_set_name and glp2.period_type=glp.period_type and glp2.period_name= :$flex$.jgsla_jelines_period_from_adj ) order by glp.period_year desc,glp.period_num desc SELECT :$flex$.period FROM DUAL Y PTB Período - Até Período - Até US Period To Period To 9 -50 :p_gl_date_from Date SELECT To_char(glp.start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')) FROM gl_periods glp ,gl_ledgers gl WHERE gl.ledger_id = :$FLEX$.JGSLA_JELINES_LEDGERS AND glp.period_set_name = gl.period_set_name AND glp.period_name = :$flex$.period Y PTB Data Inicial Data Inicial US Start Date Start Date 10 -40 :p_gl_date_to Date SELECT To_char(glp.end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')) FROM gl_periods glp ,gl_ledgers gl WHERE gl.ledger_id = :$FLEX$.JGSLA_JELINES_LEDGERS AND glp.period_set_name = gl.period_set_name AND glp.period_name = :$flex$.period_to Y PTB Data Final Data Final US End Date End Date 11 -30 :p_posting_status_code 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 = 'Y' Y PTB Status da Contabilização Status da Contabilização US Posting Status Posting Status 12 -20 :p_req_type_dummy Number select 1 from dual where :$flex$.request_type in ('AF','FC') PTB Solicitar Tipo Fictício Solicitar Tipo Fictício US Request Type Dummy Request Type Dummy 13 -10 :p_req_type_dummy1 Number select 1 from dual where :$flex$.request_type in ('DE','CO') PTB Solicitar Tipo Fictício1 Solicitar Tipo Fictício1 US Request Type Dummy1 Request Type Dummy1 14 10 :p_config_id LOV Oracle JLMX_CONFIGURATIONS Y select config_id id, config_name value, null description from jl_mx_gl_configs order by config_name Y PTB Nome da Configuração Nome da Configuração US Configuration Name Configuration Name 15 20 :p_rpt_version Char 1.3 Y PTB Versão do Relatório Auxiliar Versão do Relatório Auxiliar US Auxiliary Report Version Auxiliary Report Version 16 30 :p_je_source LOV Oracle JGSLA_SRS_JE_SOURCES_ALL Y select je_source_name id, user_je_source_name value, null description from (select user_je_source_name,je_source_name from gl_je_sources union all select meaning,'#ALL#' from xla_lookups where lookup_type='XLA_ALL') a where exists (select 1 from xla_subledgers b where b.je_source_name= decode ((select 1 from xla_subledgers where application_id=fnd_global.resp_appl_id) ,1,a.je_source_name ,b.je_source_name ) and b.application_id= decode ((select 1 from xla_subledgers where application_id=fnd_global.resp_appl_id) ,1,fnd_global.resp_appl_id ,b.application_id ) ) or (fnd_profile.value('XLA_JE_SOURCE_ALLOW_OVERRIDE')='Y' and a.je_source_name='#ALL#' ) order by upper(user_je_source_name) select meaning from xla_lookups where lookup_type = 'XLA_ALL' Y PTB Origem do Lançamento Origem do Lançamento US Journal Entry Source Journal Entry Source 17 40 :p_account_flexfield_from Char PTB Flexfield Contábil - De Flexfield Contábil - De US Accounting Flexfield From Accounting Flexfield From 18 50 :p_account_flexfield_to Char PTB Flexfield Contábil - Até Flexfield Contábil - Até US Accounting Flexfield To Accounting Flexfield To 19 60 :p_show_adj_periods 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 Mostrar Períodos de Ajuste Mostrar Períodos de Ajuste US Show Adjustment Periods Show Adjustment Periods 20 70 :p_period_from LOV Oracle JGSLA_JELINES_PERIOD_FROM_ADJ Y select period_name id, period_name value, null description from gl_ledgers gl,gl_periods glp where gl.ledger_id=:$flex$.jgsla_jelines_ledgers and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and ((nvl(:$flex$.xla_srs_yes_no,'N')='N' and glp.adjustment_period_flag='N') or(nvl(:$flex$.xla_srs_yes_no,'N')='Y')) order by glp.period_year desc,glp.period_num desc Y PTB Período Período - De US Period Period From 21 80 :p_include_zero_amount_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' PTB Incluir Quantia Zero Incluir Quantia Zero US Include Zero Amount Include Zero Amount 22 90 :p_request_type LOV Oracle JLMX_REQUEST_TYPES Y select lookup_code id, lookup_code value, meaning description from fnd_lookups where lookup_type='JLMX_REQUEST_TYPE' and trunc(nvl(end_date_active,sysdate+1))>trunc(sysdate) order by meaning AF Y PTB Tipo de Solicitação Tipo de Solicitação US Request Type Request Type 23 100 :p_audit_req_num Char Y PTB Número da Solicitação de Auditoria Número da Solicitação de Auditoria US Audit Request Number Audit Request Number 24 110 :p_audit_process_num Char Y PTB Número do Processo de Auditoria Número do Processo de Auditoria US Audit Process Number Audit Process Number 25 120 :p_seal Char PTB Lacre Lacre US Seal Seal 26 130 :p_certificate_num Char PTB Número do Certificado Número do Certificado US Certificate Number Certificate Number 27 140 :p_certificate Char PTB Certificado Certificado US Certificate Certificate