eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AP_CHARGES_V

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

View Text

SELECT AID.INVOICE_ID
, AID.INVOICE_DISTRIBUTION_ID
, AID.LINE_TYPE_LOOKUP_CODE
, ALC.DISPLAYED_FIELD
, ATC.NAME
, AID.TAX_CODE_ID
, AID.DIST_CODE_COMBINATION_ID
, AID.DESCRIPTION
, AID.AMOUNT
, AID.BASE_AMOUNT
, AID.EXCHANGE_RATE
, AID.LAST_UPDATE_DATE
, AID.LAST_UPDATED_BY
, AID.LAST_UPDATE_LOGIN
, AID.CREATION_DATE
, AID.CREATED_BY
, AID.PROGRAM_ID
, AID.PROGRAM_APPLICATION_ID
, AID.PROGRAM_UPDATE_DATE
, AID.REQUEST_ID FROM AP_INVOICE_DISTRIBUTIONS AID
, AP_LOOKUP_CODES ALC
, AP_TAX_CODES ATC
WHERE AID.LINE_TYPE_LOOKUP_CODE = ALC.LOOKUP_CODE AND AID.TAX_CODE_ID = ATC.TAX_ID (+) AND ALC.LOOKUP_TYPE = 'INVOICE DISTRIBUTION TYPE' AND LINE_TYPE_LOOKUP_CODE IN ('TAX'
, 'FREIGHT'
, 'MISCELLANEOUS')

Columns

Name
INVOICE_ID
CHARGE_DISTRIBUTION_ID
CHARGE_TYPE_LOOKUP_CODE
CHARGE_TYPE
TAX_CODE
TAX_ID
CHARGE_CCID
DESCRIPTION
CHARGE_AMOUNT
CHARGE_BASE_AMOUNT
EXCHANGE_RATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATION_DATE
CREATED_BY
PROGRAM_ID
PROGRAM_APPLICATION_ID
PROGRAM_UPDATE_DATE
REQUEST_ID