ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470BB51A9E05362FB09050512Y select jl.payment_method_code payment_method_code, jl.payment_type_flag payment_type_flag, jl.processing_type processing_type, jl.payment_id payment_id, substr(jl.payment_number,1,20) payment_number, trim(TO_CHAR(nvl(jl.payment_amount,0),'9999999999999999999990.00')) payment_amount, to_char(jl.payment_date,'YYYY-MM-DD') payment_date, DECODE(jl.PAYMENT_CUR_CODE,'MXN',null,jl.PAYMENT_CUR_CODE) PAYMENT_CUR_CODE, nvl(DECODE(jl.PAYMENT_CUR_CODE,'MXN',null,jl.PAYMENT_EXCHANGE_RATE),1) PAYMENT_EXCHANGE_RATE, substr(jl.source_acct_num,1,50) source_acct_num, decode(jl.foreign_source_bank_flag,'Y','999',substr(ce.bank_number,1,3)) source_nat_bank, decode(jl.foreign_source_bank_flag,'Y',substr(jl.source_bank_name,1,150),' ') source_frn_bank, substr(jl.dest_acct_num,1,50) dest_acct_num, decode(jl.foreign_dest_bank_flag,'Y','999', decode(:entity_code||'+'||:event_class_code,'CE_CASHFLOWS+BAT_CLASS', substr(ce2.bank_number,1,3), --bug 27946436 substr(iby.bank_number,1,3))) dest_nat_bank, decode(jl.foreign_dest_bank_flag,'Y',substr(jl.dest_bank_name,1,150),' ') dest_frn_bank, -- jl.pay_sched_num pay_sched_num, -- jl.pay_sched_cfdi pay_sched_cfdi, -- jl.pay_sched_cfd_cbb_series pay_sched_cfd_cbb_series, -- jl.pay_sched_cfd_cbb_number pay_sched_cfd_cbb_number, -- jl.PAY_SCHED_AMOUNT pay_sched_amount, jl.invoice_id invoice_id, jl.invoice_cfdi invoice_cfdi1, jl.invoice_cfd_cbb_series invoice_cfd_cbb_series1, jl.invoice_cfd_cbb_number invoice_cfd_cbb_number1, jl.foreign_invoice_number foreign_invoice_number1, trim(TO_CHAR(nvl(jl.invoice_amount,0),'9999999999999999999990.00')) inv_amt, DECODE(jl.INV_CUR_CODE,'MXN',null,jl.INV_CUR_CODE) INV_CUR_CODE1, nvl(DECODE(jl.INV_CUR_CODE,'MXN',null,jl.INV_EXCHANGE_RATE),1) INV_EXCHANGE_RATE1, jl.addit_info_1 MERCHANT_TP_ID, -- merchant_taxpayer_id of an expense line substr(jl.third_party_name,1,300) third_party_name, jl.third_party_taxpayer_id third_party_taxpayer_id1, :entity_code entity_code, NVL(ADDIT_INFO_5,'99') payment_method, ADDIT_INFO_4 payment_cfdi -- payment CFDI. from jl_mx_je_line_details_t jl, ce_banks_v ce, ce_banks_v ce2, --bug 27946436 iby_external_bank_accounts_v iby where jl.request_id = :g_con_request_id and jl.je_line_id = :je_line_id and jl.source_bank_id = ce.bank_party_id (+) and jl.dest_bank_id = ce2.bank_party_id (+) --bug 27946436 and jl.dest_acct_id = iby.bank_account_id (+) and (:entity_code in ('AP_PAYMENTS','CE_CASHFLOWS') and :event_class_code in ('PAYMENTS','RECONCILED PAYMENTS','FUTURE DATED PAYMENTS','REFUNDS','BAT_CLASS')) Union all select jl.payment_method_code payment_method_code, jl.payment_type_flag payment_type_flag, jl.processing_type processing_type, jl.payment_id payment_id, --cash_receipt_id substr(jl.addit_info_2,1,20) payment_number, -- receipt_number trim(TO_CHAR(nvl(jl.payment_amount,0),'9999999999999999999990.00')) payment_amount, -- receipt_amount to_char(jl.payment_date,'YYYY-MM-DD') payment_date, -- receipt_date DECODE(jl.PAYMENT_CUR_CODE,'MXN',null,jl.PAYMENT_CUR_CODE) PAYMENT_CUR_CODE, -- receipt_currency_code nvl(DECODE(jl.PAYMENT_CUR_CODE,'MXN',null,jl.PAYMENT_EXCHANGE_RATE),1) PAYMENT_EXCHANGE_RATE, -- receipt_exchange_Rate substr(jl.source_acct_num,1,50) source_acct_num, decode(jl.foreign_source_bank_flag,'Y','999',substr(iby.bank_number,1,3)) source_nat_bank, decode(jl.foreign_source_bank_flag,'Y',substr(jl.source_bank_name,1,150),' ') source_frn_bank, substr(jl.dest_acct_num,1,50) dest_acct_num, decode(jl.foreign_dest_bank_flag,'Y','999',substr(ce.bank_number,1,3)) dest_nat_bank, decode(jl.foreign_dest_bank_flag,'Y',substr(jl.dest_bank_name,1,150),' ') dest_frn_bank, jl.invoice_id invoice_id, jl.invoice_cfdi invoice_cfdi1, jl.invoice_cfd_cbb_series invoice_cfd_cbb_series1, jl.invoice_cfd_cbb_number invoice_cfd_cbb_number1, jl.foreign_invoice_number foreign_invoice_number1, trim(TO_CHAR(nvl(jl.invoice_amount,0),'9999999999999999999990.00')) inv_amt, DECODE(jl.INV_CUR_CODE,'MXN',null,jl.INV_CUR_CODE) INV_CUR_CODE1, nvl(DECODE(jl.INV_CUR_CODE,'MXN',null,jl.INV_EXCHANGE_RATE),1) INV_EXCHANGE_RATE1, jl.addit_info_1 MERCHANT_TP_ID, -- merchant_taxpayer_id of an expense line substr(jl.third_party_name,1,300) third_party_name, jl.third_party_taxpayer_id third_party_taxpayer_id1, :entity_code entity_code, NVL(ADDIT_INFO_5,'99') payment_method, ADDIT_INFO_4 payment_cfdi -- payment CFDI. from jl_mx_je_line_details_t jl, ce_banks_v ce, iby_external_bank_accounts_v iby where jl.request_id = :g_con_request_id and jl.je_line_id = :je_line_id and jl.DEST_BANK_ID = ce.bank_party_id (+) and jl.SOURCE_ACCT_ID = iby.bank_account_id (+) and (:entity_code ='RECEIPTS' and :event_class_code in ('RECEIPT','MISC_RECEIPT')) JL JLMXJENT_XMLP PTB JL Entradas de Lançamento Mexicano - Arquivo XML Imported from BI Publisher Application: Localizações da América Latina Source: Entradas de Lançamento Mexicano - Arquivo XML Short Name: JLMXJENT_XMLP DB package: JL_MX_JOURNAL_ENTRIES_PKG US JL Mexican Journal Entries - XML File Imported from BI Publisher Application: Latin America Localizations Source: Mexican Journal Entries - XML File Short Name: JLMXJENT_XMLP DB package: JL_MX_JOURNAL_ENTRIES_PKG BI Publisher :entity_code :event_class_code :g_con_request_id :g_precision :je_line_id :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 -100 :p_ledger Char SELECT NAME FROM GL_LEDGERS WHERE LEDGER_ID = :$flex$.ledger PTB P_LEDGER Nome do Razão US P_LEDGER Ledger Name 2 -90 :p_legal_entity Char SELECT NAME FROM XLE_FIRSTPARTY_INFORMATION_V WHERE LEGAL_ENTITY_ID = :$flex$.legal_entity PTB P_LEGAL_ENTITY Nome da Pessoa Jurídica US P_LEGAL_ENTITY Legal Entity Name 3 -80 :p_je_source_name Char SELECT :$flex$.journal_entry_source.VALUE FROM DUAL PTB P_JE_SOURCE_NAME Nome da Origem US P_JE_SOURCE_NAME Source Name 4 -70 :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 chart_of_accounts_id FROM gl_ledgers WHERE ledger_id = :$flex$.ledger PTB JGSLA_CHART_OF_ACCOUNTS ID do Plano de Contas US JGSLA_CHART_OF_ACCOUNTS Chart of Accounts ID 5 -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 6 -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$.ledger AND glp.period_set_name = gl.period_set_name AND glp.period_name = :$flex$.period Y PTB P_GL_DATE_FROM Data Inicial US P_GL_DATE_FROM Start Date 7 -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$.ledger AND glp.period_set_name = gl.period_set_name AND glp.period_name = :$flex$.period_to Y PTB P_GL_DATE_TO Data Final US P_GL_DATE_TO End Date 8 -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 9 -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 10 -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 11 10 :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 Y PTB Razão ID do Razão US Ledger Ledger ID 12 20 :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 Y PTB Pessoa Jurídica ID da Pessoa Jurídica US Legal Entity Legal Entity ID 13 30 :p_rpt_version Char 1.3 Y PTB Versão do Relatório dos Lançamentos Versão do Relatório dos Lançamentos US Journals Report Version Journals Report Version 14 40 :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 US Journal Entry Source Source 15 50 :p_account_flexfield_from Char PTB Flexfield Contábil - De Flexfield Contábil - De US Accounting Flexfield From Accounting Flexfield From 16 60 :p_account_flexfield_to Char PTB Flexfield Contábil - Até Flexfield Contábil - Até US Accounting Flexfield To Accounting Flexfield To 17 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 PTB Nome do Segmento da Subconta Nome do Segmento da Subconta US Subaccount Segment Name Subaccount Segment Name 18 80 :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 19 90 :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 20 100 :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 21 110 :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 22 120 :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 23 130 :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 24 140 :p_seal Char PTB Lacre Lacre US Seal Seal 25 150 :p_certificate_num Char PTB Número do Certificado Número do Certificado US Certificate Number Certificate Number 26 160 :p_certificate Char PTB Certificado Certificado US Certificate Certificate 27 170 :p_incl_exp_uuid LOV Oracle JLMX_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description select meaning from FND_LOOKUPS where lookup_type = 'YES_NO' and lookup_code ='N' Y PTB Incluir Informações Fiscais de Despesas Incluir Informações Fiscais de Despesas US Include Expenses Fiscal Information Include Expenses Fiscal Information