ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4709D51A9E05362FB09050512 SELECT a.*, JG_JGZZGLJRB_XMLP_PKG.legal_entity_nameformula(a.LEGAL_ENTITY_ID, :LEGAL_ENTITY_NAME) LEGAL_ENTITY_NAME, JG_JGZZGLJRB_XMLP_PKG.le_address_line_1formula(a.LEGAL_ENTITY_ID, :LE_ADDRESS_LINE_1) LE_ADDRESS_LINE_1, JG_JGZZGLJRB_XMLP_PKG.le_address_line_2formula(a.LEGAL_ENTITY_ID, :LE_ADDRESS_LINE_2) LE_ADDRESS_LINE_2, JG_JGZZGLJRB_XMLP_PKG.le_address_line_3formula(a.LEGAL_ENTITY_ID, :LE_ADDRESS_LINE_3) LE_ADDRESS_LINE_3, JG_JGZZGLJRB_XMLP_PKG.le_cityformula(a.LEGAL_ENTITY_ID, :LE_CITY) LE_CITY, JG_JGZZGLJRB_XMLP_PKG.le_postal_codeformula(a.LEGAL_ENTITY_ID, :LE_POSTAL_CODE) LE_POSTAL_CODE, JG_JGZZGLJRB_XMLP_PKG.le_registration_numberformula(a.LEGAL_ENTITY_ID, :LE_REGISTRATION_NUMBER) LE_REGISTRATION_NUMBER, JG_JGZZGLJRB_XMLP_PKG.le_activity_codeformula(a.LEGAL_ENTITY_ID, :LE_ACTIVITY_CODE) LE_ACTIVITY_CODE, JG_JGZZGLJRB_XMLP_PKG.acct_level10_valueformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL10_VALUE, JG_JGZZGLJRB_XMLP_PKG.acct_level10_value_descformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL10_VALUE_DESC, JG_JGZZGLJRB_XMLP_PKG.acct_level9_valueformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL9_VALUE, JG_JGZZGLJRB_XMLP_PKG.acct_level9_value_descformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL9_VALUE_DESC, JG_JGZZGLJRB_XMLP_PKG.acct_level8_valueformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL8_VALUE, JG_JGZZGLJRB_XMLP_PKG.acct_level8_value_descformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL8_VALUE_DESC, JG_JGZZGLJRB_XMLP_PKG.acct_level7_valueformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL7_VALUE, JG_JGZZGLJRB_XMLP_PKG.acct_level7_value_descformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL7_VALUE_DESC, JG_JGZZGLJRB_XMLP_PKG.acct_level6_valueformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL6_VALUE, JG_JGZZGLJRB_XMLP_PKG.acct_level6_value_descformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL6_VALUE_DESC, JG_JGZZGLJRB_XMLP_PKG.acct_level5_valueformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL5_VALUE, JG_JGZZGLJRB_XMLP_PKG.acct_level5_value_descformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL5_VALUE_DESC, JG_JGZZGLJRB_XMLP_PKG.acct_level4_valueformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL4_VALUE, JG_JGZZGLJRB_XMLP_PKG.acct_level4_value_descformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL4_VALUE_DESC, JG_JGZZGLJRB_XMLP_PKG.acct_level3_valueformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL3_VALUE, JG_JGZZGLJRB_XMLP_PKG.acct_level3_value_descformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL3_VALUE_DESC, JG_JGZZGLJRB_XMLP_PKG.acct_level2_valueformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL2_VALUE, JG_JGZZGLJRB_XMLP_PKG.acct_level2_value_descformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL2_VALUE_DESC, JG_JGZZGLJRB_XMLP_PKG.acct_level1_valueformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL1_VALUE, JG_JGZZGLJRB_XMLP_PKG.acct_level1_value_descformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL1_VALUE_DESC from (SELECT &SELECT_LE LEGAL_ENTITY_ID, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'N', 'VALUE') ACCT, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_value', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE') ACCT_VALUE, fnd_flex_xml_publisher_apis.process_kff_combination_1('balancing_segment_value', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'VALUE') BALANCING_SEGMENT_VALUE, fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_center_value', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'FA_COST_CTR', 'N', 'VALUE') COST_CENTER_VALUE, &INTERCOMPANY_SEGMENT_VALUE INTERCOMPANY_SEGMENT_VALUE, &MANAGEMENT_SEGMENT_VALUE MANAGEMENT_SEGMENT_VALUE, &SECONDARY_TRACK_SEGMENT_VALUE SECONDARY_TRACK_SEGMENT_VALUE, &SELECT_BEGIN_BAL BEGIN_BALANCE, GLBAL.PERIOD_NAME PERIOD_NAME, GLBAL.CODE_COMBINATION_ID CCID, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'N', 'FULL_DESCRIPTION') ACCT_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_value_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') ACCT_VALUE_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('balancing_segment_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'FULL_DESCRIPTION') BALANCING_SEGMENT_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_center_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'FA_COST_CTR', 'N', 'FULL_DESCRIPTION') COST_CENTER_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('intercompany_segment_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_INTERCOMPANY', 'N', 'DESCRIPTION') INTERCOMPANY_SEGMENT_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('management_segment_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.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#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_SECONDARY_TRACKING', 'N', 'DESCRIPTION') SEC_TRACK_SEGMENT_DESC , cc.segment1 segment1 FROM GL_PERIOD_STATUSES GLP, GL_CODE_COMBINATIONS CC, &FROM_LNSV GL_BALANCES GLBAL WHERE GLBAL.LEDGER_ID = :P_LEDGER_ID &BUDENC_WHERE_BAL AND (GLBAL.PERIOD_NET_DR != 0 OR GLBAL.PERIOD_NET_CR != 0) &CURR_WHERE_BAL AND GLBAL.CURRENCY_CODE = :BAL_CURRENCY AND GLBAL.ACTUAL_FLAG = :P_BALANCE_TYPE AND GLBAL.TEMPLATE_ID IS NULL AND GLBAL.PERIOD_NAME = GLP.PERIOD_NAME AND GLBAL.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID &LE_WHERE &PERIOD_WHERE AND GLP.APPLICATION_ID = 101 AND GLP.LEDGER_ID = :P_LEDGER_ID &DAS_WHERE &SEG_SECURITY_WHERE AND &TEMP_ACCT_WHERE AND CC.CHART_OF_ACCOUNTS_ID = :P_COA_ID) a Y JG JGZZGLJRB_XML US JG General Ledger Journal and Balance Report- Not Supported: Reserved For Future Use Imported from BI Publisher Application: Regional Localizations Source: General Ledger Journal and Balance Report (XML) - Not Supported: Reserved For Future Use Short Name: JGZZGLJRB_XML DB package: JG_JGZZGLJRB_XMLP_PKG BI Publisher &budenc_where_bal &curr_where_bal &das_where &from_lnsv &intercompany_segment_value &le_where &management_segment_value &period_where &secondary_track_segment_value &seg_security_where &select_begin_bal &select_le &temp_acct_where :acct_from_param :acct_level_param :acct_seg_value_set_id :acct_to_param :acct_where :bal_currency :balance_type_param :budenc_where_bal :budenc_where_jrnl :budgetname_encumbrancetype :chart_of_accounts_id :cp_end_date :cp_start_date :curr_where_bal :curr_where_jrnl :currency_param :currency_type_param :das_where :data_access_set_name :end_date_param :f_period_num :fp_start_date :from_lnsv :le_activity_code :le_address_line_1 :le_address_line_2 :le_address_line_3 :le_city :le_postal_code :le_registration_number :le_where :ledger_currency :ledger_name_param :legal_entity_name :p_access_set_id :p_acct_delimiter :p_acct_from :p_acct_level :p_acct_to :p_balance_type :p_bud_enc_type :p_coa_id :p_conc_request_id :p_currency_type :p_end_date :p_entered_currency :p_first_page_num :p_ledger_currency :p_ledger_id :p_page_num_format :p_period_from :p_period_to :p_start_date :p_top_level_parent_acct :p_user_param_1 :p_user_param_2 :p_user_param_3 :p_user_param_4 :p_user_param_5 :page_num_format_param :page_num_start_param :period_from_param :period_to_param :period_where :rep_execution_date :seg_security_where :select_account :select_acct_seg :select_bal_seg :select_begin_bal :select_cc_seg :select_cr :select_dr :select_ic_seg :select_le :select_mgt_seg :select_st_seg :start_date_param :t_period_num :temp_acct_where :temp_addr1 :temp_addr2 :temp_addr3 :temp_le_id :temp_le_name :temp_postal_code :temp_service_type :temp_tax_payer_id :temp_town_city :tp_end_date :user_param_1 :user_param_2 :user_param_3 :user_param_4 :user_param_5 1 -30 :p_access_set_id Number fnd_profile.value('GL_ACCESS_SET_ID') Y US Access Set ID Access Set ID 2 -20 :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 10 :p_ledger_id LOV Oracle JGZZ_SRS_LEDGER_NAME Y select l.ledger_id id, l.name value, l.description description from gl_access_set_ledgers ac,gl_ledgers_public_v l where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and l.ledger_id=ac.ledger_id order by name SELECT NAME FROM GL_LEDGERS_PUBLIC_V WHERE LEDGER_ID = GL_ACCESS_SET_SECURITY_PKG.GET_DEFAULT_LEDGER_ID(fnd_profile.value('GL_ACCESS_SET_ID'), 'R') Y US Ledger Id Ledger Id 4 20 :p_ledger_currency LOV Oracle JGZZ_SRS_LEDGER_CURRENCIES Y select currency_code id, currency_code value, null description from gl_ledgers_public_v where ledger_id=:$flex$.jgzz_srs_ledger_name order by value,description SELECT CURRENCY_CODE FROM GL_LEDGERS WHERE LEDGER_ID = :$flex$.ledger_id Y US Ledger Currency Ledger Currency 5 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 6 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 7 50 :p_balance_type LOV Oracle JGZZ_SRS_BALANCE_TYPE Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='BATCH_TYPE' and (lookup_code!='E' or :$flex$.jgzz_srs_gl_currency_type='T') order by meaning SELECT MEANING FROM GL_LOOKUPS WHERE LOOKUP_TYPE = 'BATCH_TYPE' AND LOOKUP_CODE = 'A' Y US Balance Type Balance Type 8 60 :p_bud_enc_type LOV Oracle JGZZ_SRS_BUD_ENCUM_NAME Y select budget_encumbrance_id id, budget_encumbrance_name value, null description from jg_zz_srs_ledger_bud_encum_v where actual_flag=:$flex$.jgzz_srs_balance_type and decode(actual_flag,'A',:$flex$.jgzz_srs_ledger_name, 'E',:$flex$.jgzz_srs_ledger_name, ledger_id)=:$flex$.jgzz_srs_ledger_name order by value,description SELECT DECODE(:$flex$.balance_type, 'A', MEANING, NULL) FROM GL_LOOKUPS WHERE LOOKUP_TYPE = 'LITERAL' AND LOOKUP_CODE='N/A' Y US Budget or Encumbrance Name Budget or Encumbrance Name 9 70 :p_start_date Date US Start Date Start Date 10 80 :p_end_date Date US End Date End Date 11 90 :p_acct_from Char Y US Account From Account From 12 100 :p_acct_to Char Y US Account To Account To 13 110 :p_period_from LOV Oracle JGZZ_SRS_PERIOD_START Y select period_name id, period_name value, null description from jg_zz_srs_ledger_per_start_v where actual_flag=:$flex$.jgzz_srs_balance_type and ledger_id=:$flex$.jgzz_srs_ledger_name and decode(actual_flag,'B',budget_encumbrance_id, :$flex$.jgzz_srs_bud_encum_name) =:$flex$.jgzz_srs_bud_encum_name order by period_year desc,period_num desc Y US Period From Period From 14 120 :p_period_to LOV Oracle JGZZ_SRS_PERIOD_END Y select period_name id, period_name value, null description from jg_zz_srs_ledger_per_start_v where actual_flag=:$flex$.jgzz_srs_balance_type and ledger_id=:$flex$.jgzz_srs_ledger_name and decode(actual_flag,'B',budget_encumbrance_id, :$flex$.jgzz_srs_bud_encum_name) =:$flex$.jgzz_srs_bud_encum_name and effective_period_num>= (select effective_period_num from gl_srs_ledger_period_start where period_name=:$flex$.jgzz_srs_period_start and actual_flag=:$flex$.jgzz_srs_balance_type and ledger_id=:$flex$.jgzz_srs_ledger_name and decode(actual_flag,'B',budget_encumbrance_id, :$flex$.jgzz_srs_bud_encum_name) =:$flex$.jgzz_srs_bud_encum_name) order by period_year desc,effective_period_num desc Y US Period To Period To 15 130 :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 16 140 :p_top_level_parent_acct Char US Top Level Parent Account Top Level Parent Account 17 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 18 160 :p_first_page_num Number US First Page Number First Page Number 19 170 :p_user_param_1 Char US User Parameter 1 User Parameter 1 20 180 :p_user_param_2 Char US User Parameter 2 User Parameter 2 21 190 :p_user_param_3 Char US User Parameter 3 User Parameter 3 22 200 :p_user_param_4 Char US User Parameter 4 User Parameter 4 23 210 :p_user_param_5 Char US User Parameter 5 User Parameter 5