JG Journal Allocation - Rule Set Listing - draft

Description
Categories: BI Publisher
Columns: Set Name, Set Allow Partial Allocation, Set Account Type, Cc Range Id, Cc Range Low, Cc Range High, Cc Description, Acc Range Low, Acc Range High, Acc Offset Account ...
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
Rule Set Name
 
LOV Oracle
Ledger ID
 
Number
JGZZ_SRS_COA_ID_BYSOB
 
LOV Oracle