[Home] [Help]
View: AP_CHARGE_ALLOCATIONS_V
View Text
SELECT AID.INVOICE_ID
, AID.INVOICE_DISTRIBUTION_ID
, AID.DISTRIBUTION_LINE_NUMBER
, AID.LINE_TYPE_LOOKUP_CODE
, ALC.DISPLAYED_FIELD
, AID.DESCRIPTION
, AID.AMOUNT FROM AP_INVOICE_DISTRIBUTIONS AID
, AP_LOOKUP_CODES ALC
WHERE AID.LINE_TYPE_LOOKUP_CODE = ALC.LOOKUP_CODE AND ALC.LOOKUP_TYPE = 'INVOICE DISTRIBUTION TYPE' AND AID.LINE_TYPE_LOOKUP_CODE IN ('ITEM'
, 'MISCELLANEOUS'
, 'FREIGHT'
, 'PREPAY')
Columns
Name |
INVOICE_ID |
INVOICE_DISTRIBUTION_ID |
DISTRIBUTION_LINE_NUMBER |
LINE_TYPE_LOOKUP_CODE |
LINE_TYPE |
DESCRIPTION |
DISTRIBUTION_AMOUNT |