Product: | AP - Payables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AP_ALLOCATION_RULES_V |
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