AR AutoCash Rules

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