JG Journal Allocation - Rule Set Listing- Not Supported: Reserved For Future Use
Description
- Categories
- BI Publisher
- 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
Imported from BI Publisher
Journal Allocation - Rule Set Listing
Journal Allocation - Rule Set Listing
SQL 26 lines
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 |
Parameters 1
| Parameter | Type | List of values SQL |
|---|---|---|
| Rule Set Name | LOV Oracle |