ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470AA51A9E05362FB09050512 SELECT ACCOUNT , ACCOUNT_SEGMENT_VALUE, BALANCING_SEGMENT_VALUE, COST_CENTER_VALUE, INTERCOMPANY_SEGMENT_VALUE, MANAGEMENT_SEGMENT_VALUE, SEC_TRACK_SEGMENT_VALUE, ACCOUNT_TYPE, &SELECT_LE LEGAL_ENTITY_ID, decode(:P_ZERO_BYB, 'Y', 0, YEAR_BEGIN_DR) ADJ_BEGIN_YEAR_DR, decode(:P_ZERO_BYB, 'Y', 0, YEAR_BEGIN_CR) ADJ_BEGIN_YEAR_CR, ADJ_FIRST_PERIOD_DR, ADJ_FIRST_PERIOD_CR, FROM_PERIOD_BEGIN_DR - nvl(YEAR_BEGIN_DR, 0) PRIOR_PERIOD_DR, FROM_PERIOD_BEGIN_CR - nvl(YEAR_BEGIN_CR, 0) PRIOR_PERIOD_CR, PERIODS_TOTAL_DR PERIOD_DR, PERIODS_TOTAL_CR PERIOD_CR, TO_PERIOD_END_DR - decode(:P_ZERO_BYB, 'Y', YEAR_BEGIN_DR, 0) END_BALANCE_DR, TO_PERIOD_END_CR - decode(:P_ZERO_BYB, 'Y', YEAR_BEGIN_CR, 0) END_BALANCE_CR, decode(SIGN(decode(:P_ZERO_BYB,'Y',0,YEAR_BEGIN_DR - YEAR_BEGIN_CR)),1,YEAR_BEGIN_DR - YEAR_BEGIN_CR,0) NET_BEGIN_DR_BAL, decode(SIGN(decode(:P_ZERO_BYB,'Y',0,YEAR_BEGIN_DR - YEAR_BEGIN_CR)),-1,YEAR_BEGIN_CR - YEAR_BEGIN_DR,0) NET_BEGIN_CR_BAL, decode(SIGN(decode(:P_ZERO_BYB, 'Y',(TO_PERIOD_END_DR - YEAR_BEGIN_DR) - (TO_PERIOD_END_CR - YEAR_BEGIN_CR),TO_PERIOD_END_DR - TO_PERIOD_END_CR)),1,decode(:P_ZERO_BYB, 'Y',(TO_PERIOD_END_DR - YEAR_BEGIN_DR) - (TO_PERIOD_END_CR - YEAR_BEGIN_CR),TO_PERIOD_END_DR - TO_PERIOD_END_CR),0) NET_ENDING_DR_BAL, decode(SIGN(decode(:P_ZERO_BYB, 'Y',(TO_PERIOD_END_DR - YEAR_BEGIN_DR) - (TO_PERIOD_END_CR - YEAR_BEGIN_CR),TO_PERIOD_END_DR - TO_PERIOD_END_CR)),-1,decode(:P_ZERO_BYB, 'Y',(TO_PERIOD_END_CR - YEAR_BEGIN_CR) - (TO_PERIOD_END_DR - YEAR_BEGIN_DR),TO_PERIOD_END_CR - TO_PERIOD_END_DR),0) NET_ENDING_CR_BAL, ACCT ACCT, ACCT_DESC ACCT_DESC, JL_JGZZGLTRB_XMLP_PKG.le_nameformula(&SELECT_LE, :LE_NAME) LE_NAME, JL_JGZZGLTRB_XMLP_PKG.le_addr1formula(&SELECT_LE, :LE_ADDR1) LE_ADDR1, JL_JGZZGLTRB_XMLP_PKG.le_addr2formula(&SELECT_LE, :LE_ADDR2) LE_ADDR2, JL_JGZZGLTRB_XMLP_PKG.le_addr3formula(&SELECT_LE, :LE_ADDR3) LE_ADDR3, JL_JGZZGLTRB_XMLP_PKG.le_cityformula(&SELECT_LE, :LE_CITY) LE_CITY, JL_JGZZGLTRB_XMLP_PKG.le_postal_codeformula(&SELECT_LE, :LE_POSTAL_CODE) LE_POSTAL_CODE, JL_JGZZGLTRB_XMLP_PKG.le_service_typeformula(&SELECT_LE, :LE_SERVICE_TYPE) LE_SERVICE_TYPE, JL_JGZZGLTRB_XMLP_PKG.le_tax_payer_idformula(&SELECT_LE, :LE_TAX_PAYER_ID) LE_TAX_PAYER_ID, JL_JGZZGLTRB_XMLP_PKG.acct_valueformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_VALUE, ACCT_VALUE_DESC ACCT_VALUE_DESC, BALANCING_SEGMENT_DESC BALANCING_SEGMENT_DESC, COST_CENTER_DESC COST_CENTER_DESC, INTERCOMPANY_SEGMENT_DESC INTERCOMPANY_SEGMENT_DESC, MANAGEMENT_SEGMENT_DESC MANAGEMENT_SEGMENT_DESC, SEC_TRACK_SEGMENT_DESC SEC_TRACK_SEGMENT_DESC, JL_JGZZGLTRB_XMLP_PKG.acct_level1_valueformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL1_VALUE, JL_JGZZGLTRB_XMLP_PKG.acct_level1_value_descformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL1_VALUE_DESC, JL_JGZZGLTRB_XMLP_PKG.acct_level2_valueformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL2_VALUE, JL_JGZZGLTRB_XMLP_PKG.acct_level2_value_descformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL2_VALUE_DESC, JL_JGZZGLTRB_XMLP_PKG.acct_level3_valueformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL3_VALUE, JL_JGZZGLTRB_XMLP_PKG.acct_level3_value_descformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL3_VALUE_DESC, JL_JGZZGLTRB_XMLP_PKG.acct_level4_valueformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL4_VALUE, JL_JGZZGLTRB_XMLP_PKG.acct_level4_value_descformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL4_VALUE_DESC, JL_JGZZGLTRB_XMLP_PKG.acct_level5_valueformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL5_VALUE, JL_JGZZGLTRB_XMLP_PKG.acct_level5_value_descformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL5_VALUE_DESC, JL_JGZZGLTRB_XMLP_PKG.acct_level6_valueformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL6_VALUE, JL_JGZZGLTRB_XMLP_PKG.acct_level6_value_descformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL6_VALUE_DESC, JL_JGZZGLTRB_XMLP_PKG.acct_level7_valueformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL7_VALUE, JL_JGZZGLTRB_XMLP_PKG.acct_level7_value_descformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL7_VALUE_DESC, JL_JGZZGLTRB_XMLP_PKG.acct_level8_valueformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL8_VALUE, JL_JGZZGLTRB_XMLP_PKG.acct_level8_value_descformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL8_VALUE_DESC, JL_JGZZGLTRB_XMLP_PKG.acct_level9_valueformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL9_VALUE, JL_JGZZGLTRB_XMLP_PKG.acct_level9_value_descformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL9_VALUE_DESC, JL_JGZZGLTRB_XMLP_PKG.acct_level10_value_descformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL10_VALUE_DESC, JL_JGZZGLTRB_XMLP_PKG.acct_level10_valueformula(ACCOUNT_SEGMENT_VALUE, :ACCT_VALUE_DESC) ACCT_LEVEL10_VALUE, FROM_PERIOD_BEGIN_DR - nvl(YEAR_BEGIN_DR, 0) PRIOR_PERIOD_DR, FROM_PERIOD_BEGIN_CR - nvl(YEAR_BEGIN_CR, 0) PRIOR_PERIOD_CR, PERIODS_TOTAL_DR PERIOD_DR, PERIODS_TOTAL_CR PERIOD_CR, TO_PERIOD_END_DR - decode(:P_ZERO_BYB, 'Y', YEAR_BEGIN_DR, 0) END_BALANCE_DR, TO_PERIOD_END_CR - decode(:P_ZERO_BYB, 'Y', YEAR_BEGIN_CR, 0) END_BALANCE_CR, decode(SIGN(decode(:P_ZERO_BYB,'Y',0,YEAR_BEGIN_DR - YEAR_BEGIN_CR)),1,YEAR_BEGIN_DR - YEAR_BEGIN_CR,0) NET_BEGIN_DR_BAL, decode(SIGN(decode(:P_ZERO_BYB,'Y',0,YEAR_BEGIN_DR - YEAR_BEGIN_CR)),-1,YEAR_BEGIN_CR - YEAR_BEGIN_DR,0) NET_BEGIN_CR_BAL, decode(SIGN(decode(:P_ZERO_BYB, 'Y',(TO_PERIOD_END_DR - YEAR_BEGIN_DR) - (TO_PERIOD_END_CR - YEAR_BEGIN_CR),TO_PERIOD_END_DR - TO_PERIOD_END_CR)),1,decode(:P_ZERO_BYB, 'Y',(TO_PERIOD_END_DR - YEAR_BEGIN_DR) - (TO_PERIOD_END_CR - YEAR_BEGIN_CR),TO_PERIOD_END_DR - TO_PERIOD_END_CR),0) NET_ENDING_DR_BAL, decode(SIGN(decode(:P_ZERO_BYB, 'Y',(TO_PERIOD_END_DR - YEAR_BEGIN_DR) - (TO_PERIOD_END_CR - YEAR_BEGIN_CR),TO_PERIOD_END_DR - TO_PERIOD_END_CR)),-1,decode(:P_ZERO_BYB, 'Y',(TO_PERIOD_END_CR - YEAR_BEGIN_CR) - (TO_PERIOD_END_DR - YEAR_BEGIN_DR),TO_PERIOD_END_CR - TO_PERIOD_END_DR),0) NET_ENDING_CR_BAL FROM (SELECT &SELECT_ACCOUNT ACCOUNT, max(&SELECT_ACCT_SEG) ACCOUNT_SEGMENT_VALUE, max(&SELECT_BAL_SEG) BALANCING_SEGMENT_VALUE, max(&SELECT_CC_SEG) COST_CENTER_VALUE, max(&SELECT_IC_SEG) INTERCOMPANY_SEGMENT_VALUE, max(&SELECT_MGT_SEG) MANAGEMENT_SEGMENT_VALUE, max(&SELECT_ST_SEG) SEC_TRACK_SEGMENT_VALUE, max(gcc.account_type) ACCOUNT_TYPE, max(null) LEGAL_ENTITY_ID, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') ACCT, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'N', 'DESCRIPTION') ACCT_DESC, sum(decode(bal.period_name, :FIRST_PERIOD_NAME, decode(:P_CURRENCY_TYPE, 'E', decode(nvl(bal.translated_flag,'R'),'R', nvl(bal.begin_balance_dr, 0), nvl(bal.begin_balance_dr_beq, 0)), nvl(bal.begin_balance_dr, 0)), 0)) YEAR_BEGIN_DR, sum(decode(bal.period_name, :FIRST_PERIOD_NAME, decode(:P_CURRENCY_TYPE, 'E', decode(nvl(bal.translated_flag,'R'), 'R', nvl(bal.begin_balance_cr, 0), nvl(bal.begin_balance_cr_beq, 0)), nvl(bal.begin_balance_cr, 0)), 0)) YEAR_BEGIN_CR, sum(decode(:P_PERIOD_FROM, :FIRST_PERIOD_NAME, 0, decode(:FIRST_PERIOD_ADJ_FLAG, 'Y', decode(bal.period_name, :FIRST_PERIOD_NAME, decode(:P_CURRENCY_TYPE, 'E', decode(nvl(bal.translated_flag,'R'), 'R', nvl(bal.period_net_dr, 0), nvl(bal.period_net_dr_beq, 0)), nvl(bal.period_net_dr, 0)), 0), 0))) ADJ_FIRST_PERIOD_DR, sum(decode(:P_PERIOD_FROM, :FIRST_PERIOD_NAME, 0, decode(:FIRST_PERIOD_ADJ_FLAG, 'Y', decode(bal.period_name, :FIRST_PERIOD_NAME, decode(:P_CURRENCY_TYPE, 'E', decode(nvl(bal.translated_flag, 'R'),'R', nvl(bal.period_net_cr, 0), nvl(bal.period_net_cr_beq, 0)), nvl(bal.period_net_cr, 0)), 0), 0))) ADJ_FIRST_PERIOD_CR, sum(decode(bal.period_name, :P_PERIOD_FROM, decode(:P_CURRENCY_TYPE, 'E', decode(nvl(bal.translated_flag,'R'), 'R', nvl(bal.begin_balance_dr, 0), nvl(bal.begin_balance_dr_beq, 0)), nvl(bal.begin_balance_dr, 0)), 0)) FROM_PERIOD_BEGIN_DR, sum(decode(bal.period_name, :P_PERIOD_FROM, decode(:P_CURRENCY_TYPE, 'E', decode(nvl(bal.translated_flag, 'R'),'R', nvl(bal.begin_balance_cr, 0), nvl(bal.begin_balance_cr_beq, 0)), nvl(bal.begin_balance_cr, 0)), 0)) FROM_PERIOD_BEGIN_CR, sum(decode(bal.period_name, :FIRST_PERIOD_NAME, decode(:P_PERIOD_FROM, :FIRST_PERIOD_NAME, decode(:P_CURRENCY_TYPE, 'E', decode(nvl(bal.translated_flag, 'R'),'R', nvl(bal.period_net_dr, 0), nvl(bal.period_net_dr_beq, 0)), nvl(bal.period_net_dr, 0)), 0), decode(:P_CURRENCY_TYPE, 'E', decode(nvl(bal.translated_flag, 'R'),'R', nvl(bal.period_net_dr, 0), nvl(bal.period_net_dr_beq, 0)), nvl(bal.period_net_dr, 0)))) PERIODS_TOTAL_DR, sum(decode(bal.period_name, :FIRST_PERIOD_NAME, decode(:P_PERIOD_FROM, :FIRST_PERIOD_NAME, decode(:P_CURRENCY_TYPE, 'E', decode(nvl(bal.translated_flag, 'R'),'R', nvl(bal.period_net_cr, 0), nvl(bal.period_net_cr_beq, 0)), nvl(bal.period_net_cr, 0)), 0), decode(:P_CURRENCY_TYPE, 'E', decode(nvl(bal.translated_flag, 'R'),'R', nvl(bal.period_net_cr, 0), nvl(bal.period_net_cr_beq, 0)), nvl(bal.period_net_cr, 0)))) PERIODS_TOTAL_CR, sum(decode(bal.period_name, :P_PERIOD_TO, decode(:P_CURRENCY_TYPE, 'E', decode(nvl(bal.translated_flag,'R'), 'R', nvl(bal.begin_balance_dr, 0) + nvl(bal.period_net_dr, 0), nvl(bal.begin_balance_dr_beq, 0) + nvl(bal.period_net_dr_beq, 0)), nvl(bal.begin_balance_dr, 0) + nvl(bal.period_net_dr, 0)), 0)) TO_PERIOD_END_DR, sum(decode(bal.period_name, :P_PERIOD_TO, decode(:P_CURRENCY_TYPE, 'E', decode(nvl(bal.translated_flag, 'R'),'R', nvl(bal.begin_balance_cr, 0) + nvl(bal.period_net_cr, 0), nvl(bal.begin_balance_cr_beq, 0) + nvl(bal.period_net_cr_beq, 0)), nvl(bal.begin_balance_cr, 0) + nvl(bal.period_net_cr, 0)), 0)) TO_PERIOD_END_CR, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_value_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'DESCRIPTION') ACCT_VALUE_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('balancing_segment_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'DESCRIPTION') BALANCING_SEGMENT_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_center_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'FA_COST_CTR', 'N', 'DESCRIPTION') COST_CENTER_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('intercompany_segment_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_INTERCOMPANY', 'N', 'DESCRIPTION') INTERCOMPANY_SEGMENT_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('management_segment_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_MANAGEMENT', 'N', 'DESCRIPTION') MANAGEMENT_SEGMENT_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('sec_track_segment_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_SECONDARY_TRACKING', 'N', 'DESCRIPTION') SEC_TRACK_SEGMENT_DESC FROM GL_CODE_COMBINATIONS gcc, GL_BALANCES bal WHERE gcc.chart_of_accounts_id = :COA_ID and decode(:P_REPORT_TYPE, null, :PER_TO_END_DATE, nvl(gcc.start_date_active, :PER_TO_END_DATE)) <= :PER_TO_END_DATE and &WHERE_ACCT_RANGE &WHERE_ACCT_CLASS and bal.ledger_id = :P_LEDGER_ID and bal.code_combination_id = gcc.code_combination_id and bal.period_name IN ( select per.period_name from GL_PERIODS per where per.period_set_name = :PERIOD_SET_NAME &WHERE_PERIOD) and bal.currency_code = decode(:P_CURRENCY_TYPE, 'T', :P_LEDGER_CURRENCY, :P_ENTERED_CURRENCY) &WHERE_TRANSLATED_FLAG and bal.actual_flag = 'A' and bal.template_id IS NULL &WHERE_DEGREE &WHERE_DAS GROUP BY &SELECT_ACCOUNT,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE'),fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'N', 'DESCRIPTION'),fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_value_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'DESCRIPTION'),fnd_flex_xml_publisher_apis.process_kff_combination_1('balancing_segment_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'DESCRIPTION'),fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_center_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'FA_COST_CTR', 'N', 'DESCRIPTION'),fnd_flex_xml_publisher_apis.process_kff_combination_1('intercompany_segment_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_INTERCOMPANY', 'N', 'DESCRIPTION'),fnd_flex_xml_publisher_apis.process_kff_combination_1('management_segment_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_MANAGEMENT', 'N', 'DESCRIPTION'),fnd_flex_xml_publisher_apis.process_kff_combination_1('sec_track_segment_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_SECONDARY_TRACKING', 'N', 'DESCRIPTION')) &FROM_LNSV &WHERE_LE ORDER BY ACCOUNT_SEGMENT_VALUE, LEGAL_ENTITY_ID JL JLCBGLTRB_XML US JL General Ledger Inventory and Balances Book Report- Not Supported: Reserved For Future Use Imported from BI Publisher Application: Latin America Localizations Source: General Ledger Inventory and Balances Book Report (XML) - Not Supported: Reserved For Future Use Short Name: JLCBGLTRB_XML DB package: JL_JGZZGLTRB_XMLP_PKG BI Publisher &from_lnsv &select_account &select_acct_seg &select_bal_seg &select_cc_seg &select_ic_seg &select_le &select_mgt_seg &select_st_seg &where_acct_class &where_acct_range &where_das &where_degree &where_le &where_period &where_translated_flag :acct_seg_value_set_id :acct_value_desc :coa_id :data_access_set_name :first_period_adj_flag :first_period_name :from_lnsv :l_period_set_name :le_addr1 :le_addr2 :le_addr3 :le_city :le_name :le_postal_code :le_service_type :le_tax_payer_id :p_access_set_id :p_acct_class :p_acct_delimiter :p_acct_level :p_appl_name :p_conc_request_id :p_currency_type :p_entered_currency :p_kff_from :p_kff_to :p_ledger_currency :p_ledger_id :p_page_num_format :p_period_from :p_period_to :p_report_type :p_top_parent_value :p_user_p1 :p_user_p10 :p_user_p2 :p_user_p3 :p_user_p4 :p_user_p5 :p_user_p6 :p_user_p7 :p_user_p8 :p_user_p9 :p_zero_byb :param_acct_class :param_acct_from :param_acct_level :param_acct_to :param_currency :param_currency_type :param_ledger_name :param_page_num_format :param_period_from :param_period_to :param_report_type :param_top_parent_value :param_user_1 :param_user_10 :param_user_2 :param_user_3 :param_user_4 :param_user_5 :param_user_6 :param_user_7 :param_user_8 :param_user_9 :param_zero_begin_year_bal :per_from_start_date :per_to_end_date :period_from_start_date :period_set_name :period_to_end_date :report_exec_date :select_account :select_acct_seg :select_bal_seg :select_cc_seg :select_ic_seg :select_le :select_mgt_seg :select_st_seg :sys_name_ver :temp_le_addr1 :temp_le_addr2 :temp_le_addr3 :temp_le_city :temp_le_id :temp_le_name :temp_le_postal_code :temp_le_service_type :temp_le_tax_payer_id :user_name :where_acct_class :where_acct_range :where_das :where_degree :where_le :where_period :where_translated_flag 1 -40 :p_access_set_id Number fnd_profile.value('GL_ACCESS_SET_ID') Y US Access Set Id Access Set Id 2 -30 :p_coa_id LOV Oracle JGZZ_SRS_COA_ID_BYSOB Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from gl_access_sets where access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') order by value,description SELECT chart_of_accounts_id FROM gl_access_sets WHERE access_set_id = fnd_profile.value('GL_ACCESS_SET_ID') Y US Chart Of Accounts Id Chart Of Accounts Id 3 -20 :p_ledger_id Number SELECT TARGET_LEDGER_ID FROM GL_LEDGER_RELATIONSHIPS WHERE APPLICATION_ID = 101 AND SOURCE_LEDGER_ID = TARGET_LEDGER_ID AND TARGET_LEDGER_NAME = :$flex$.ledger Y US JGZZ_SRS_LEDGER_ID_UNVALIDATED Ledger Id 4 10 :p_ledger_name LOV Oracle JGZZ_SRS_LEDGER_NO_SET Y select nvl(rel.target_ledger_name,led.name) id, nvl(rel.target_ledger_name,led.name) value, led.description description from gl_access_set_ledgers ac,gl_ledgers_public_v led,gl_ledger_relationships rel where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and led.ledger_id=ac.ledger_id and rel.source_ledger_id(+)=ac.ledger_id and rel.target_ledger_id(+)=ac.ledger_id and rel.application_id(+)=101 order by nvl(rel.target_ledger_name,led.name) select name from gl_ledgers where ledger_id = gl_access_set_security_pkg.get_default_ledger_id(fnd_profile.value('GL_ACCESS_SET_ID'), 'R') Y US Ledger Ledger 5 20 :p_ledger_currency LOV Oracle JGZZ_SRS_LEDGER_CURRENCIES_GLTB Y select target_currency_code id, target_currency_code value, null description from gl_ledger_relationships where application_id=101 and source_ledger_id=target_ledger_id and target_ledger_name=:$flex$.jgzz_srs_ledger_no_set order by value,description SELECT TARGET_CURRENCY_CODE FROM GL_LEDGER_RELATIONSHIPS WHERE APPLICATION_ID = 101 AND SOURCE_LEDGER_ID = TARGET_LEDGER_ID AND TARGET_LEDGER_NAME = :$flex$.ledger Y US Ledger Currency Ledger Currency 6 30 :p_currency_type LOV Oracle JGZZ_SRS_GL_CURRENCY_TYPE Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='GL_CURRENCY_TYPE' and lookup_code in ('T','S','E') order by meaning SELECT meaning FROM gl_lookups WHERE LOOKUP_TYPE = 'GL_CURRENCY_TYPE' and lookup_code = 'T' Y US Currency Type Currency Type 7 40 :p_entered_currency LOV Oracle JGZZ_SRS_ENTERED_CURRENCIES Y select currency_code id, currency_code value, null description from jg_zz_entered_currencies_v where currency_type=:$flex$.jgzz_srs_gl_currency_type order by value,description SELECT CURRENCY_CODE FROM JG_ZZ_ENTERED_CURRENCIES_V WHERE CURRENCY_TYPE = DECODE(:$flex$.currency_type, 'S', 'S', 'T', 'T', NULL) Y US Entered Currency Entered Currency 8 50 :p_kff_from Char Y US Account From Account From 9 60 :p_kff_to Char Y US Account To Account To 10 70 :p_period_from LOV Oracle JGZZ_SRS_GL_PERIOD_START_NO_SET Y select p.period_name id, p.period_name value, null description from gl_period_statuses p where p.application_id=101 and p.ledger_id=:$flex$.jgzz_srs_ledger_id_unvalidated and p.closing_status in ('O','C','P') order by p.period_year desc,p.period_num desc Y US Period From Period From 11 80 :p_period_to LOV Oracle JGZZ_SRS_GL_PERIOD_END_SAME_YEAR_NO_SET Y select p2.period_name id, p2.period_name value, null description from gl_period_statuses p,gl_period_statuses p2 where p.application_id=101 and p.ledger_id=:$flex$.jgzz_srs_ledger_id_unvalidated and p.period_name=:$flex$.jgzz_srs_gl_period_start_no_set and p2.application_id=101 and p2.ledger_id=:$flex$.jgzz_srs_ledger_id_unvalidated and p2.closing_status in ('O','C','P') and p2.period_year=p.period_year and p2.effective_period_num>=p.effective_period_num order by p2.period_year desc,p2.period_num desc Y US Period To Period To 12 90 :p_acct_level LOV Oracle JGZZ_DEGREE Y select lookup_code id, lookup_code value, description description from fnd_lookup_values where lookup_type='JGZZ_DEGREE' and enabled_flag='Y' and language=userenv('LANG') order by value,description US Account Level Account Level 13 100 :p_top_parent_value Char US Top Level Parent Account Top Level Parent Account 14 110 :p_acct_class LOV Oracle JGZZ_SRS_ACCOUNT_CLASS Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='JGZZ_ACCOUNT_CLASS' order by value,description select meaning from fnd_lookups where lookup_type = 'JGZZ_ACCOUNT_CLASS' and lookup_code = 'ALL' Y US Account Class Account Class 15 120 :p_acct_delimiter LOV Oracle JGZZ_SRS_ACCOUNT_DELIMITER Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='JGZZ_ACCOUNT_DELIMITER' order by value,description US Account Delimiter Account Delimiter 16 130 :p_zero_byb LOV Oracle JGZZ_SRS_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 Zero Beginning of Year Balance Zero Beginning of Year Balance 17 140 :p_report_type LOV Oracle JGZZ_SRS_GL_TRIAL_BALANCE_TYPE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='JGZZ_GL_TB_TYPE' order by value,description US Trial Balance Type Trial Balance Type 18 150 :p_page_num_format LOV Oracle JGZZ_SRS_PAGE_NUM_FORMAT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='JGZZ_PAGE_NUM_FORMAT' order by value,description select meaning from fnd_lookups where lookup_type = 'JGZZ_PAGE_NUM_FORMAT' and lookup_code = 'PAGE_N_OF_M' Y US Page Number Format Page Number Format 19 160 :p_user_p1 Char US User Parameter 1 User Parameter 1 20 170 :p_user_p2 Char US User Parameter 2 User Parameter 2 21 180 :p_user_p3 Char US User Parameter 3 User Parameter 3 22 190 :p_user_p4 Char US User Parameter 4 User Parameter 4 23 200 :p_user_p5 Char US User Parameter 5 User Parameter 5 :$flex$.currency_type Currency Type Entered Currency :$flex$.jgzz_srs_gl_currency_type Currency Type Entered Currency :$flex$.jgzz_srs_gl_period_start_no_set Period From Period To :$flex$.jgzz_srs_ledger_id_unvalidated JGZZ_SRS_LEDGER_ID_UNVALIDATED Period From :$flex$.jgzz_srs_ledger_id_unvalidated JGZZ_SRS_LEDGER_ID_UNVALIDATED Period To :$flex$.jgzz_srs_ledger_no_set Ledger Ledger Currency :$flex$.ledger Ledger JGZZ_SRS_LEDGER_ID_UNVALIDATED :$flex$.ledger Ledger Ledger Currency