ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470A251A9E05362FB09050512 SELECT rs.name set_name, DECODE(rs.partial_allocation,'Y','*') set_allow_partial_allocation, l.meaning set_account_type, cc.cc_range_id cc_range_id, cc.cc_range_low cc_range_low, cc.cc_range_high cc_range_high, cc.description cc_description, acc.account_range_low acc_range_low, acc.account_range_high acc_range_high, acc.offset_account acc_offset_account, rl.allocation_percent rule_percent, rl.natural_account rule_account, rl.offset_account rule_offset_account FROM jg_zz_ta_rule_sets rs, fnd_lookups l, jg_zz_ta_cc_ranges cc, jg_zz_ta_account_ranges acc, jg_zz_ta_rule_lines rl WHERE rl.account_range_id = acc.account_range_id AND acc.cc_range_id = cc.cc_range_id AND cc.rule_set_id = rs.rule_set_id AND rs.account_type = l.lookup_code(+) AND NVL(l.lookup_type,'ACCOUNT_TYPE') = 'ACCOUNT_TYPE' AND rs.rule_set_id = NVL(:P_RULE_SET_ID,rs.rule_set_id) ORDER BY 1 ASC,4 ASC,5 ASC,6 ASC,8 ASC,9 ASC Y JG JGZZTAJA-RL_XML US JG Journal Allocation - Rule Set Listing- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Journal Allocation - Rule Set Listing Application: Regional Localizations Source: Journal Allocation - Rule Set Listing (XML) - Not Supported: Reserved For Future Use Short Name: JGZZTAJA-RL_XML DB package: JG_JGZZTAJA_XMLP_PKG BI Publisher :c_set_of_books_name :c_the_end :cp_date_format :cp_rows_selected :p_chart_of_accounts_id :p_conc_request_id :p_debug_mode :p_rule_set_id :p_set_of_books_id :p_sql_trace 1 -50 :p_set_of_books_id Number fnd_profile.value('GL_SET_OF_BKS_ID') Y US Ledger ID Ledger ID 2 -40 :p_sql_trace Char N US SQL Trace SQL Trace 3 -20 :p_chart_of_accounts_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 JGZZ_SRS_COA_ID_BYSOB Chart of Accounts ID 4 10 :p_rule_set_id LOV Oracle JGZZ_RULE_SET Y select rule_set_id id, name value, null description from jg_zz_ta_rule_sets where chart_of_accounts_id=:$flex$.jgzz_srs_coa_id_bysob and enabled_flag='Y' order by value,description US Rule Set Name Rule Set Name