VIEW: APPS.AP_CHARGES_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')