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
Description: AutoCash Rules Report
Application: Receivables
Source: AutoCash Rules (XML)
Short Name: ARXPAR_XML
DB package: AR_ARXPAR_XMLP_PKG
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 |