View: FA_INVOICE_DETAILS_V

Product:	OFA - Assets
Description:
Implementation/DBA Data:	APPS.FA_INVOICE_DETAILS_V

View Text

SELECT AI.ROWID ROW_ID
, AI.ASSET_ID
, AI.PO_VENDOR_ID
, AI.ASSET_INVOICE_ID
, AI.FIXED_ASSETS_COST
, AI.DATE_EFFECTIVE
, AI.DATE_INEFFECTIVE
, AI.INVOICE_TRANSACTION_ID_IN
, AI.INVOICE_TRANSACTION_ID_OUT
, AI.DELETED_FLAG
, AI.PO_NUMBER
, AI.INVOICE_NUMBER
, AI.PAYABLES_BATCH_NAME
, AI.PAYABLES_CODE_COMBINATION_ID
, AI.FEEDER_SYSTEM_NAME
, AI.CREATE_BATCH_DATE
, AI.CREATE_BATCH_ID
, AI.INVOICE_DATE
, AI.PAYABLES_COST
, AI.POST_BATCH_ID
, AI.INVOICE_ID
, AI.AP_DISTRIBUTION_LINE_NUMBER
, AI.PAYABLES_UNITS
, AI.SPLIT_MERGED_CODE
, AI.DESCRIPTION
, AI.PARENT_MASS_ADDITION_ID
, AI.LAST_UPDATE_DATE
, AI.LAST_UPDATED_BY
, AI.LAST_UPDATE_LOGIN
, AI.CREATED_BY
, AI.CREATION_DATE
, AI.ATTRIBUTE1
, AI.ATTRIBUTE2
, AI.ATTRIBUTE3
, AI.ATTRIBUTE4
, AI.ATTRIBUTE5
, AI.ATTRIBUTE6
, AI.ATTRIBUTE7
, AI.ATTRIBUTE8
, AI.ATTRIBUTE9
, AI.ATTRIBUTE10
, AI.ATTRIBUTE11
, AI.ATTRIBUTE12
, AI.ATTRIBUTE13
, AI.ATTRIBUTE14
, AI.ATTRIBUTE15
, AI.ATTRIBUTE_CATEGORY_CODE
, AI.UNREVALUED_COST
, AI.MERGED_CODE
, AI.SPLIT_CODE
, AI.MERGE_PARENT_MASS_ADDITIONS_ID
, AI.SPLIT_PARENT_MASS_ADDITIONS_ID
, AI.PROJECT_ASSET_LINE_ID
, AI.PROJECT_ID
, AI.TASK_ID
, PO.SEGMENT1 VENDOR_NUMBER
, PO.VENDOR_NAME
, AI.SOURCE_LINE_ID
, AI.DEPRECIATE_IN_GROUP_FLAG
, AI.MATERIAL_INDICATOR_FLAG
, AI.PRIOR_SOURCE_LINE_ID
, AI.INVOICE_DISTRIBUTION_ID
, AI.INVOICE_LINE_NUMBER
, AI.PO_DISTRIBUTION_ID
FROM PO_VENDORS PO
, FA_ASSET_INVOICES AI
WHERE AI.DATE_INEFFECTIVE IS NULL
AND PO.VENDOR_ID(+) = AI.PO_VENDOR_ID

Columns