AR AutoCash Rules

Description
Categories: BI Publisher
Imported from BI Publisher
Description: AutoCash Rules Report
Application: Receivables
Source: AutoCash Rules (XML)
Short Name: ARXPAR_XML
DB package: AR_ARXPAR_XMLP_PKG
Run AR AutoCash Rules and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT	
        arch.autocash_hierarchy_id id,
	arch.hierarchy_name name,
	arch.description descrpt,
	SUBSTRB(st.meaning,1,18) status,
	SUBSTRB(disc.meaning,1,30) discnt,
	decode(include_finance_charges, 'Y', :nls_yes, :nls_no) chrgs,
	decode(include_dispute_items, 'Y', :nls_yes, :nls_no) dispute,
	decode(apply_partial_payments, 'Y', :nls_yes, :nls_no) partial,
	SUBSTRB(rem.meaning,1,30) remit,
	rule.rule_sequence sequence,
	SUBSTRB(lk.meaning,1,60) app_rule
FROM
	ar_lookups lk,
	ar_lookups st,
	ar_lookups disc,
	ar_lookups rem,
	ar_autocash_rules rule,
	ar_autocash_hierarchies arch
WHERE
	arch.autocash_hierarchy_id = rule.autocash_hierarchy_id
AND
	st.lookup_type	= 'CODE_STATUS'	and
	st.lookup_code	= arch.status
AND
	disc.lookup_type= 'AUTOCASH_DISCOUNTS'	and
	disc.lookup_code= arch.include_discounts
AND
	rem.lookup_type	= 'AUTOCASH_REMAINING_AMOUNT'	and
	rem.lookup_code = arch.remaining_amount
AND
	lk.lookup_type = 'AUTOCASH_RULE'	and
	lk.lookup_code = rule.autocash_rule
ORDER BY arch.hierarchy_name,arch.autocash_hierarchy_id,rule.rule_sequence
Parameter Name SQL text Validation
Operating Unit
 
LOV