View: FA_INS_ADDITIONS_V

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

View Text

SELECT FAD.ROWID ROW_ID
, FAD.ASSET_ID
, FAD.ASSET_NUMBER
, FAD.ASSET_KEY_CCID
, FAD.CURRENT_UNITS
, FAD.ASSET_TYPE
, FAD.TAG_NUMBER
, FADT.DESCRIPTION
, FAD.ASSET_CATEGORY_ID
, FAD.PARENT_ASSET_ID
, FAD.MANUFACTURER_NAME
, FAD.SERIAL_NUMBER
, FAD.MODEL_NUMBER
, FAD.PROPERTY_TYPE_CODE
, FAD.PROPERTY_1245_1250_CODE
, FAD.IN_USE_FLAG
, FAD.OWNED_LEASED
, FAD.NEW_USED
, FAD.UNIT_ADJUSTMENT_FLAG
, FAD.ADD_COST_JE_FLAG
, FAD.ATTRIBUTE1
, FAD.ATTRIBUTE2
, FAD.ATTRIBUTE3
, FAD.ATTRIBUTE4
, FAD.ATTRIBUTE5
, FAD.ATTRIBUTE6
, FAD.ATTRIBUTE7
, FAD.ATTRIBUTE8
, FAD.ATTRIBUTE9
, FAD.ATTRIBUTE10
, FAD.ATTRIBUTE11
, FAD.ATTRIBUTE12
, FAD.ATTRIBUTE13
, FAD.ATTRIBUTE14
, FAD.ATTRIBUTE15
, FAD.ATTRIBUTE16
, FAD.ATTRIBUTE17
, FAD.ATTRIBUTE18
, FAD.ATTRIBUTE19
, FAD.ATTRIBUTE20
, FAD.ATTRIBUTE21
, FAD.ATTRIBUTE22
, FAD.ATTRIBUTE23
, FAD.ATTRIBUTE24
, FAD.ATTRIBUTE25
, FAD.ATTRIBUTE26
, FAD.ATTRIBUTE27
, FAD.ATTRIBUTE28
, FAD.ATTRIBUTE29
, FAD.ATTRIBUTE30
, FAD.ATTRIBUTE_CATEGORY_CODE
, FAD.CONTEXT
, FAD.LEASE_ID
, FAD.LAST_UPDATE_DATE
, FAD.LAST_UPDATED_BY
, FAD.CREATED_BY
, FAD.CREATION_DATE
, FAD.LAST_UPDATE_LOGIN
, FAD.GLOBAL_ATTRIBUTE1
, FAD.GLOBAL_ATTRIBUTE2
, FAD.GLOBAL_ATTRIBUTE3
, FAD.GLOBAL_ATTRIBUTE4
, FAD.GLOBAL_ATTRIBUTE5
, FAD.GLOBAL_ATTRIBUTE6
, FAD.GLOBAL_ATTRIBUTE7
, FAD.GLOBAL_ATTRIBUTE8
, FAD.GLOBAL_ATTRIBUTE9
, FAD.GLOBAL_ATTRIBUTE10
, FAD.GLOBAL_ATTRIBUTE11
, FAD.GLOBAL_ATTRIBUTE12
, FAD.GLOBAL_ATTRIBUTE13
, FAD.GLOBAL_ATTRIBUTE14
, FAD.GLOBAL_ATTRIBUTE15
, FAD.GLOBAL_ATTRIBUTE16
, FAD.GLOBAL_ATTRIBUTE17
, FAD.GLOBAL_ATTRIBUTE18
, FAD.GLOBAL_ATTRIBUTE19
, FAD.GLOBAL_ATTRIBUTE20
, FAD.GLOBAL_ATTRIBUTE_CATEGORY
, FAD.INVENTORIAL
, BKS.BOOK_TYPE_CODE
, BKS.COST ASSET_COST
, BKS.DATE_PLACED_IN_SERVICE
, FAB.CURRENT_FISCAL_YEAR CUR_FA_YEAR
, GSB.CURRENCY_CODE
, FAK.CODE_COMBINATION_ID
, FAK.SEGMENT1
, FAK.SEGMENT2
, FAK.SEGMENT3
, FAK.SEGMENT4
, FAK.SEGMENT5
, FAK.SEGMENT6
, FAK.SEGMENT7
, FAK.SEGMENT8
, FAK.SEGMENT9
, FAK.SEGMENT10
FROM FA_BOOK_CONTROLS FAB
, GL_SETS_OF_BOOKS GSB
, FA_BOOKS BKS
, FA_ASSET_KEYWORDS FAK
, FA_ADDITIONS_B FAD
, FA_ADDITIONS_TL FADT
WHERE GSB.SET_OF_BOOKS_ID = FAB.SET_OF_BOOKS_ID
AND FAB.BOOK_TYPE_CODE = BKS.BOOK_TYPE_CODE
AND BKS.ASSET_ID = FAD.ASSET_ID
AND BKS.DATE_INEFFECTIVE IS NULL
AND BKS.PERIOD_COUNTER_FULLY_RETIRED IS NULL
AND BKS.COST >= 0
AND BKS.ASSET_ID = FAD.ASSET_ID
AND FAD.ASSET_KEY_CCID = FAK.CODE_COMBINATION_ID(+)
AND FADT.ASSET_ID = FAD.ASSET_ID
AND FADT.LANGUAGE = USERENV('LANG')

Columns