View: FA_ADD_INVOICE_WEB_V

Product:	OFA - Assets
Description:	Invoice information pertaining to the asset
Implementation/DBA Data:	APPS.FA_ADD_INVOICE_WEB_V

View Text

SELECT AI.ROWID ROW_ID
, AI.ASSET_ID
, AI.PO_VENDOR_ID
, AI.ASSET_INVOICE_ID
, TO_CHAR(AI.FIXED_ASSETS_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) 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
, TO_CHAR(AI.PAYABLES_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) PAYABLES_COST
, AI.POST_BATCH_ID
, AI.INVOICE_ID
, AI.AP_DISTRIBUTION_LINE_NUMBER
, AI.PAYABLES_UNITS
, AI.SPLIT_MERGED_CODE
, AI.DESCRIPTION INVOICE_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
, TO_CHAR(AI.UNREVALUED_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) 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
, PO.INVOICE_CURRENCY_CODE
, AD.ASSET_NUMBER
, AD.ASSET_TYPE
, AD.TAG_NUMBER
, AD.DESCRIPTION ASSET_DESCRIPTION
, AD.ASSET_KEY_CCID
, AD.ASSET_CATEGORY_ID
, AD.LEASE_ID
, CA.CATEGORY_TYPE
, CA.CAPITALIZE_FLAG
, AK.CONCATENATED_SEGMENTS ASSET_KEY
, CK.CONCATENATED_SEGMENTS CATEGORY
, AI.INVOICE_LINE_NUMBER
FROM FA_ADDITIONS AD
, FA_CATEGORIES_B CA
, FA_CATEGORIES_B_KFV CK
, FA_ASSET_KEYWORDS_KFV AK
, PO_VENDORS PO
, FA_ASSET_INVOICES AI
, FA_BOOKS BK
, FA_BOOK_CONTROLS BC
, GL_SETS_OF_BOOKS GLSB
WHERE AD.ASSET_ID = AI.ASSET_ID
AND AD.ASSET_CATEGORY_ID = CA.CATEGORY_ID(+)
AND AD.ASSET_KEY_CCID = AK.CODE_COMBINATION_ID(+)
AND AD.ASSET_CATEGORY_ID = CK.CATEGORY_ID(+)
AND AI.DATE_INEFFECTIVE IS NULL
AND PO.VENDOR_ID(+) = AI.PO_VENDOR_ID
AND AI.ASSET_ID = BK.ASSET_ID
AND BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BK.TRANSACTION_HEADER_ID_OUT IS NULL
AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND BC.BOOK_CLASS = 'CORPORATE'

Columns