ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470AB51A9E05362FB09050512 SELECT nvl(src.user_je_source_name, '**********') SOURCE, src.je_source_name SOURCE_ID, ps.period_name PERIOD_NAME, ps.effective_period_num PERIOD_EFF_NUM, jeh.currency_code CURRENCY1, cc.code_combination_id CCID, null ACCOUNT, TO_CHAR(jel.effective_date, 'DD-MON-YYYY') EFFECTIVE_DATE, jel.description DESCRIPTION, jeb.name BATCH_NAME, jeh.name HEADER_NAME, jel.entered_dr DEBITS, jel.entered_cr CREDITS, nvl(jel.reference_1,' ') REFERENCE_1, jel.reference_2 REFERENCE_2, jel.reference_3 REFERENCE_3, jel.reference_4 REFERENCE_4, nvl(jel.reference_5,' ') REFERENCE_5, jel.reference_6 REFERENCE_6, jel.reference_7 REFERENCE_7, jel.reference_8 REFERENCE_8, jel.reference_9 REFERENCE_9, jel.reference_10 REFERENCE_10, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_desc_all', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') C_DESC_ALL, JL_JLCLGCAL_XMLP_PKG.c_doc_numformula(nvl ( src.user_je_source_name , '**********' ), jel.reference_6, jel.reference_4, nvl ( jel.reference_5 , ' ' ), jel.reference_8) C_Doc_Num, JL_JLCLGCAL_XMLP_PKG.c_documentformula(src.je_source_name, jel.reference_10, jel.reference_9) C_Document FROM gl_code_combinations cc, gl_je_lines jel, gl_je_headers jeh, gl_je_batches jeb, gl_sets_of_books sob, gl_period_statuses ps, gl_je_sources src WHERE sob.set_of_books_id = :P_SET_OF_BOOKS_ID AND ps.set_of_books_id = sob.set_of_books_id AND ps.application_id = 101 AND ps.effective_period_num BETWEEN :START_EFFECTIVE_PERIOD_NUM AND :END_EFFECTIVE_PERIOD_NUM AND ps.closing_status IN ('C', 'O', 'P') AND ps.period_name = jel.period_name AND sob.chart_of_accounts_id = cc.chart_of_accounts_id AND jel.code_combination_id = cc.code_combination_id AND jel.status || '' = 'P' AND (jel.entered_dr != 0 OR jel.entered_cr != 0) AND jel.ledger_id = sob.set_of_books_id AND jeh.je_header_id = jel.je_header_id AND jeh.actual_flag = 'A' AND jeb.je_batch_id = jeh.je_batch_id AND jeb.average_journal_flag = 'N' AND src.je_source_name = jeh.je_source &P_DYNAMIC_WHERE ORDER BY jeh.currency_code, ps.period_year, ps.period_num, TO_NUMBER(TO_CHAR(jel.effective_date, 'MM')), TO_NUMBER(TO_CHAR(jel.effective_date, 'DD')) JL JLCLGCAL_XML US JL Chilean General Ledger Cash Ledger- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Chilean General Ledger Cash Ledger Application: Latin America Localizations Source: Chilean General Ledger Cash Ledger (XML) - Not Supported: Reserved For Future Use Short Name: JLCLGCAL_XML DB package: JL_JLCLGCAL_XMLP_PKG BI Publisher &p_dynamic_where :c_account_end :c_account_start :c_acct :cp_comp_address1 :cp_comp_address2 :cp_comp_estab_type :cp_comp_name :cp_comp_taxpayer_id :cp_date4_format :cp_model_name :delimiter :end_effective_period_num :p_chart_of_accts_id :p_company_id :p_company_info :p_conc_request_id :p_debug_switch :p_dynamic_where :p_end_period :p_flexdata :p_legal_entity_id :p_max_flex :p_min_flex :p_min_precision :p_model_id :p_set_of_books_id :p_start_period :p_trace_switch :set_of_books_name :start_effective_period_num :struct_num :where_flex 1 -40 :p_reporting_level LOV Oracle XLE_LEGAL_REPORTING_LEVEL Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='FND_MO_REPORTING_LEVEL' order by value,description 1000 US XLE_LEGAL_REPORTING_LEVEL Reporting Level 2 -30 :p_set_of_books_id Number fnd_profile.value('GL_SET_OF_BKS_ID') US GL_SET_OF_BOOKS_ID Ledger ID 3 -20 :p_chart_of_accts_id LOV Oracle GL_SRS_COA_ID_BYSOB Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from gl_sets_of_books where set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID') order by value,description SELECT chart_of_accounts_id FROM gl_sets_of_books WHERE set_of_books_id = fnd_profile.value('GL_SET_OF_BKS_ID') Y US Chart of Accounts ID Chart of Accounts ID 4 10 :p_legal_entity_id LOV Oracle JLCO_COMPANY_NAME Y select legal_entity_id id, legal_entity_name value, null description from gl_ledger_le_v where :$flex$.reporting_level='1000' and ledger_id=:$flex$.gl_set_of_books_id order by value,description US Company Name Legal Entity 5 20 :p_start_period LOV Oracle GL_SRS_PERIOD_NAMES_BCK Y select period_name id, period_name value, null description from gl_period_statuses where closing_status in ('O','C','P') and ledger_id=:$flex$.gl_srs_null_num and application_id=101 order by period_year desc,period_num desc Y US Period From Start Period Name 6 30 :p_end_period LOV Oracle GL_SRS_PERIOD_NAMES_BCK_END Y select period_name id, period_name value, null description from gl_period_statuses where closing_status in ('O','C','P') and set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID') and application_id=101 and (start_date>=(select start_date from gl_period_statuses where period_name=:$flex$.gl_srs_period_names_bck and set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID') and application_id=101)) order by period_year desc,period_num desc Y US Period To End Period Name 7 40 :p_model_id LOV Oracle JLZZ_GL_ACCT_MODEL Y select model_id id, name value, null description from jl_zz_gl_axi_models where set_of_books_id=:$flex$.gl_set_of_books_id order by value,description Y US Account Model Cash Account Model Names 8 50 :p_company_info LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'YES_NO' AND LOOKUP_CODE = 'N' Y US Print Legal Entity Information Print Company Information :$flex$.gl_set_of_books_id GL_SET_OF_BOOKS_ID Account Model :$flex$.gl_set_of_books_id GL_SET_OF_BOOKS_ID Company Name :$flex$.gl_srs_period_names_bck Period From Period To