JG Journal Allocation - Rule Set Listing - draft

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
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
JGZZ_SRS_COA_ID_BYSOB
 
LOV Oracle
Ledger ID
 
Number
Rule Set Name
 
LOV Oracle