ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1833869E053B46B63588994Y SELECT natural_account || ' ' || subaccount account, TRIM(TO_CHAR(ROUND(NVL(BEGIN_BALANCE,0), :G_PRECISION),'9999999999999999999990.00')) begin_balance, TRIM(TO_CHAR(ROUND(NVL(PERIOD_NET_DR,0), :G_PRECISION),'9999999999999999999990.00')) period_net_dr, TRIM(TO_CHAR(ROUND(NVL(PERIOD_NET_CR,0), :G_PRECISION),'9999999999999999999990.00')) period_net_cr, TRIM(TO_CHAR(ROUND(NVL(END_BALANCE,0), :G_PRECISION),'9999999999999999999990.00')) end_balance FROM (Select * From jl_mx_gl_accounts_t Order By natural_account, subaccount) jl_mx_gl_accounts_t WHERE Sat_account IS NOT NULL AND ( NVL(BEGIN_BALANCE,0) <> 0 Or NVL(PERIOD_NET_DR,0) <> 0 Or NVL(PERIOD_NET_CR,0) <> 0 Or NVL(END_BALANCE,0) <> 0) CONNECT BY parent_account = Prior natural_account START WITH parent_account IS NULL JL JLMXTBAL_XMLP US JL Mexican Trial Balance - XML File Application: Latin America Localizations Source: Mexican Trial Balance - XML File Short Name: JLMXTBAL_XMLP DB package: JL_MX_TBAL_PKG BI Publisher :g_debug_flag :g_error_buffer :g_precision :l_tbal_mod_date :p_adj_period :p_certificate :p_certificate_num :p_config_id :p_incl_stat_jrns :p_period :p_remm_type :p_seal :p_tbal_mod_date :p_tbal_version 1 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 US Configuration Name 2 20 :p_tbal_version Char 1.3 Y US Trial Balance Version 3 30 :p_period LOV Oracle JLMX_PERIODS Y select period_name id, period_name value, null description from gl_period_statuses where ledger_id in (select ledger_id from jl_mx_gl_configs where config_id=:$flex$.jlmx_configurations) and closing_status='C' and adjustment_period_flag='N' and application_id=101 order by period_year desc,period_num desc Y US Period 4 40 :p_adj_period LOV Oracle JLMX_ADJ_PERIODS Y select period_name id, period_name value, null description from gl_period_statuses where ledger_id in (select ledger_id from jl_mx_gl_configs where config_id=:$flex$.jlmx_configurations) and closing_status='C' and adjustment_period_flag='Y' and application_id=101 order by period_year desc,period_num desc US Adjustment Period 5 50 :p_remm_type LOV Oracle JLMX_REMM_TYPES Y select lookup_code id, lookup_code value, meaning description from fnd_lookups where lookup_type= 'JLMX_REMM_TYPE' and trunc(nvl(end_date_active,sysdate+1))>trunc(sysdate) order by meaning Y US Remittance Type 6 60 :p_tbal_mod_date Date US Trial Balance Modified Date 7 70 :p_seal Char US Seal 8 80 :p_certificate_num Char US Certificate Number 9 90 :p_certificate Char US Certificate 10 100 :p_incl_stat_jrns 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 US Include Statistical Balances