VIEW: APPS.FA_INVOICE_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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