VIEW: APPS.FA_INS_ADDITIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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