JG Journal Allocation - Rule Set Listing- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
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
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
Run
JG Journal Allocation - Rule Set Listing- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Rule Set Name |
|
LOV Oracle |