[Home] [Help]
View: 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
Name |
ROW_ID |
INVOICE_ID |
TO_INVOICE_LINE_NUMBER |
LINE_TYPE_LOOKUP_CODE |
LINE_TYPE |
DESCRIPTION |
LINE_AMOUNT |