View: AP_ALLOCATED_LINES_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.AP_ALLOCATED_LINES_V

View Text

SELECT ARL.INVOICE_ID
, ARL.TO_INVOICE_LINE_NUMBER
, AIL.LINE_NUMBER
, AIL.LINE_TYPE_LOOKUP_CODE CHRG_TYPE_LOOKUP_CODE
, ALC.DISPLAYED_FIELD CHRG_TYPE
, AIL.DESCRIPTION
, AIL.AMOUNT CHRG_LINE_AMOUNT
, ARL.PERCENTAGE ALLOCATED_PERCENTAGE
, ARL.AMOUNT
, ARL.CREATED_BY
, ARL.CREATION_DATE
, ARL.LAST_UPDATED_BY
, ARL.LAST_UPDATE_DATE
, ARL.LAST_UPDATE_LOGIN
FROM AP_INVOICE_LINES AIL
, AP_ALLOCATION_RULE_LINES ARL
, AP_LOOKUP_CODES ALC
WHERE AIL.INVOICE_ID = ARL.INVOICE_ID
AND AIL.LINE_NUMBER = ARL.CHRG_INVOICE_LINE_NUMBER
AND AIL.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT'
, 'MISCELLANEOUS'
, 'TAX')
AND ALC.LOOKUP_TYPE = 'INVOICE LINE TYPE'
AND AIL.LINE_TYPE_LOOKUP_CODE = ALC.LOOKUP_CODE UNION SELECT ARL.INVOICE_ID
, ARL.TO_INVOICE_LINE_NUMBER
, AIL.LINE_NUMBER
, AIL.LINE_TYPE_LOOKUP_CODE CHRG_TYPE_LOOKUP_CODE
, ALC.DISPLAYED_FIELD CHRG_TYPE
, AIL.DESCRIPTION
, AIL.AMOUNT CHRG_LINE_AMOUNT
, ARL.PERCENTAGE ALLOCATED_PERCENTAGE
, ARL.AMOUNT
, ARL.CREATED_BY
, ARL.CREATION_DATE
, ARL.LAST_UPDATED_BY
, ARL.LAST_UPDATE_DATE
, ARL.LAST_UPDATE_LOGIN
FROM AP_INVOICE_LINES AIL
, AP_ALLOCATION_RULE_LINES_GT ARL
, AP_LOOKUP_CODES ALC
WHERE AIL.INVOICE_ID = ARL.INVOICE_ID
AND AIL.LINE_NUMBER = ARL.CHRG_INVOICE_LINE_NUMBER
AND AIL.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT'
, 'MISCELLANEOUS'
, 'TAX')
AND ALC.LOOKUP_TYPE = 'INVOICE LINE TYPE'
AND AIL.LINE_TYPE_LOOKUP_CODE = ALC.LOOKUP_CODE

Columns