VIEW: APPS.AP_ALLOCATION_RULES_V

Source

View Text - Preformatted

SELECT ap_alr.rowid row_id, ail.invoice_id, ail.line_number chrg_invoice_line_number, ail.line_type_lookup_code chrg_type_lookup_code, alc1.displayed_field charge_type, ail.description, ail.amount chrg_line_amount, ail.included_tax_amount, (ail.amount - nvl(ail.included_tax_amount,0)), NVL(ap_alr.rule_type, 'PRORATION'), NVL(ap_alr.rule_generation_type, 'USER'), alc2.displayed_field rule_generation_type, NVL(ap_alr.status, 'PENDING'), alc3.displayed_field, ap_alr.created_by, ap_alr.creation_date, ap_alr.last_updated_by, ap_alr.last_update_date, ap_alr.last_update_login FROM ap_invoice_lines ail, ap_allocation_rules ap_alr, ap_lookup_codes alc1, ap_lookup_codes alc2, ap_lookup_codes alc3 WHERE ail.invoice_id = ap_alr.invoice_id(+) AND ail.line_number = ap_alr.chrg_invoice_line_number(+) AND alc1.lookup_type = 'INVOICE LINE TYPE' AND alc1.lookup_code = ail.line_type_lookup_code AND ail.line_type_lookup_code IN ('FREIGHT', 'MISCELLANEOUS', 'TAX') AND alc2.lookup_type(+) = 'ALLOCATION GENERATION TYPE' AND alc2.lookup_code(+) = ap_alr.rule_generation_type AND alc3.lookup_type(+) = 'ALLOCATION STATUS' AND alc3.lookup_code(+) = ap_alr.status

View Text - HTML Formatted

SELECT AP_ALR.ROWID ROW_ID
, AIL.INVOICE_ID
, AIL.LINE_NUMBER CHRG_INVOICE_LINE_NUMBER
, AIL.LINE_TYPE_LOOKUP_CODE CHRG_TYPE_LOOKUP_CODE
, ALC1.DISPLAYED_FIELD CHARGE_TYPE
, AIL.DESCRIPTION
, AIL.AMOUNT CHRG_LINE_AMOUNT
, AIL.INCLUDED_TAX_AMOUNT
, (AIL.AMOUNT - NVL(AIL.INCLUDED_TAX_AMOUNT
, 0))
, NVL(AP_ALR.RULE_TYPE
, 'PRORATION')
, NVL(AP_ALR.RULE_GENERATION_TYPE
, 'USER')
, ALC2.DISPLAYED_FIELD RULE_GENERATION_TYPE
, NVL(AP_ALR.STATUS
, 'PENDING')
, ALC3.DISPLAYED_FIELD
, AP_ALR.CREATED_BY
, AP_ALR.CREATION_DATE
, AP_ALR.LAST_UPDATED_BY
, AP_ALR.LAST_UPDATE_DATE
, AP_ALR.LAST_UPDATE_LOGIN
FROM AP_INVOICE_LINES AIL
, AP_ALLOCATION_RULES AP_ALR
, AP_LOOKUP_CODES ALC1
, AP_LOOKUP_CODES ALC2
, AP_LOOKUP_CODES ALC3
WHERE AIL.INVOICE_ID = AP_ALR.INVOICE_ID(+)
AND AIL.LINE_NUMBER = AP_ALR.CHRG_INVOICE_LINE_NUMBER(+)
AND ALC1.LOOKUP_TYPE = 'INVOICE LINE TYPE'
AND ALC1.LOOKUP_CODE = AIL.LINE_TYPE_LOOKUP_CODE
AND AIL.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT'
, 'MISCELLANEOUS'
, 'TAX')
AND ALC2.LOOKUP_TYPE(+) = 'ALLOCATION GENERATION TYPE'
AND ALC2.LOOKUP_CODE(+) = AP_ALR.RULE_GENERATION_TYPE
AND ALC3.LOOKUP_TYPE(+) = 'ALLOCATION STATUS'
AND ALC3.LOOKUP_CODE(+) = AP_ALR.STATUS