View: AP_APPLICABLE_LINES_V

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

View Text

SELECT AIL.ROWID ROW_ID
, AIL.INVOICE_ID
, AIL.LINE_NUMBER TO_INVOICE_LINE_NUMBER
, AIL.LINE_TYPE_LOOKUP_CODE
, ALC.DISPLAYED_FIELD LINE_TYPE
, AIL.DESCRIPTION
, AIL.AMOUNT LINE_AMOUNT
FROM AP_INVOICE_LINES AIL
, AP_LOOKUP_CODES ALC
WHERE ALC.LOOKUP_TYPE = 'INVOICE LINE TYPE'
AND AIL.LINE_TYPE_LOOKUP_CODE = ALC.LOOKUP_CODE

Columns