eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: FA_FUTURE_MASS_ADDITIONS_V

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

View Text

SELECT AD.ROWID ROW_ID
, 'ADDITIONS'
, AD.ASSET_ID
, AD.ASSET_NUMBER
, AD.ASSET_KEY_CCID
, AD.CURRENT_UNITS
, AD.ASSET_TYPE
, AD.TAG_NUMBER
, AD.DESCRIPTION
, AD.ASSET_CATEGORY_ID
, AD.PARENT_ASSET_ID
, AD.MANUFACTURER_NAME
, AD.SERIAL_NUMBER
, AD.MODEL_NUMBER
, AD.PROPERTY_TYPE_CODE
, AD.PROPERTY_1245_1250_CODE
, AD.IN_USE_FLAG
, AD.OWNED_LEASED
, AD.NEW_USED
, AD.UNIT_ADJUSTMENT_FLAG
, AD.ADD_COST_JE_FLAG
, AD.ATTRIBUTE1
, AD.ATTRIBUTE2
, AD.ATTRIBUTE3
, AD.ATTRIBUTE4
, AD.ATTRIBUTE5
, AD.ATTRIBUTE6
, AD.ATTRIBUTE7
, AD.ATTRIBUTE8
, AD.ATTRIBUTE9
, AD.ATTRIBUTE10
, AD.ATTRIBUTE11
, AD.ATTRIBUTE12
, AD.ATTRIBUTE13
, AD.ATTRIBUTE14
, AD.ATTRIBUTE15
, AD.ATTRIBUTE16
, AD.ATTRIBUTE17
, AD.ATTRIBUTE18
, AD.ATTRIBUTE19
, AD.ATTRIBUTE20
, AD.ATTRIBUTE21
, AD.ATTRIBUTE22
, AD.ATTRIBUTE23
, AD.ATTRIBUTE24
, AD.ATTRIBUTE25
, AD.ATTRIBUTE26
, AD.ATTRIBUTE27
, AD.ATTRIBUTE28
, AD.ATTRIBUTE29
, AD.ATTRIBUTE30
, AD.ATTRIBUTE_CATEGORY_CODE
, AD.CONTEXT
, AD.LEASE_ID
, AD.LAST_UPDATE_DATE
, AD.LAST_UPDATED_BY
, AD.CREATED_BY
, AD.CREATION_DATE
, AD.LAST_UPDATE_LOGIN
, PAD.ASSET_NUMBER PARENT_ASSET
, PAD.DESCRIPTION PARENT_DESCRIPTION
, PV.VENDOR_NAME LESSOR
, LEASE.LEASE_NUMBER
, LEASE.DESCRIPTION LEASE_DESC
, LEASE.LESSOR_ID
, LEASE.ATTRIBUTE1 LS_ATTRIBUTE1
, LEASE.ATTRIBUTE2 LS_ATTRIBUTE2
, LEASE.ATTRIBUTE3 LS_ATTRIBUTE3
, LEASE.ATTRIBUTE4 LS_ATTRIBUTE4
, LEASE.ATTRIBUTE5 LS_ATTRIBUTE5
, LEASE.ATTRIBUTE6 LS_ATTRIBUTE6
, LEASE.ATTRIBUTE7 LS_ATTRIBUTE7
, LEASE.ATTRIBUTE8 LS_ATTRIBUTE8
, LEASE.ATTRIBUTE9 LS_ATTRIBUTE9
, LEASE.ATTRIBUTE10 LS_ATTRIBUTE10
, LEASE.ATTRIBUTE11 LS_ATTRIBUTE11
, LEASE.ATTRIBUTE12 LS_ATTRIBUTE12
, LEASE.ATTRIBUTE13 LS_ATTRIBUTE13
, LEASE.ATTRIBUTE14 LS_ATTRIBUTE14
, LEASE.ATTRIBUTE15 LS_ATTRIBUTE15
, LEASE.ATTRIBUTE_CATEGORY_CODE LS_ATTRIBUTE_CATEGORY_CODE
, CA.CATEGORY_TYPE
, CA.CAPITALIZE_FLAG
, BK.DATE_PLACED_IN_SERVICE
, BK.COST
, BK.BOOK_TYPE_CODE
, BK.GROUP_ASSET_ID
, GAD.ASSET_NUMBER GROUP_ASSET_NUMBER
FROM FA_ADDITIONS_NON_SEC_VL AD
, FA_ADDITIONS_NON_SEC_VL PAD
, FA_LEASES LEASE
, PO_VENDORS PV
, FA_CATEGORIES CA
, FA_BOOKS BK
, FA_BOOK_CONTROLS BC
, FA_ADDITIONS_B GAD
WHERE AD.PARENT_ASSET_ID = PAD.ASSET_ID ( + )
AND AD.LEASE_ID = LEASE.LEASE_ID ( + )
AND PV.VENDOR_ID ( + ) = LEASE.LESSOR_ID
AND AD.ASSET_CATEGORY_ID = CA.CATEGORY_ID
AND AD.ASSET_ID = BK.ASSET_ID
AND BK.DATE_INEFFECTIVE IS NULL
AND BC.BOOK_TYPE_CODE = BK.BOOK_TYPE_CODE
AND BC.BOOK_CLASS = 'CORPORATE'
AND BK.GROUP_ASSET_ID = GAD.ASSET_ID (+)
AND EXISTS (SELECT 1
FROM FA_BOOKS FABK
, FA_DISTRIBUTION_HISTORY DH
, FA_ADDITIONS FAD
WHERE DH.ASSET_ID = FAD.ASSET_ID
AND DH.BOOK_TYPE_CODE = BK.BOOK_TYPE_CODE
AND DH.DATE_INEFFECTIVE IS NULL
AND FABK.ASSET_ID = FAD.ASSET_ID
AND FAD.ASSET_ID = BK.ASSET_ID
AND FABK.BOOK_TYPE_CODE = BK.BOOK_TYPE_CODE
AND FABK.DATE_INEFFECTIVE IS NULL
AND FABK.PERIOD_COUNTER_FULLY_RETIRED IS NULL
AND NOT EXISTS (SELECT 1
FROM FA_RETIREMENTS FARET
WHERE FARET.ASSET_ID = FAD.ASSET_ID
AND FARET.BOOK_TYPE_CODE = FABK.BOOK_TYPE_CODE
AND FARET.STATUS IN ( 'PENDING'
, 'REINSTATE'
, 'PARTIAL'))) UNION ALL SELECT ROW_ID
, 'MASSADDITIONS' ROW_TYPE
, ASSET_ID
, ASSET_NUMBER
, ASSET_KEY_CCID
, FIXED_ASSETS_UNITS
, ASSET_TYPE
, TAG_NUMBER
, DESCRIPTION
, ASSET_CATEGORY_ID
, PARENT_ASSET_ID
, MANUFACTURER_NAME
, SERIAL_NUMBER
, MODEL_NUMBER
, PROPERTY_TYPE_CODE
, PROPERTY_1245_1250_CODE
, IN_USE_FLAG
, OWNED_LEASED
, NEW_USED
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, LEASE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, NULL
, NULL
, LESSOR
, LEASE_NUMBER
, LEASE_DESC
, LESSOR_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DATE_PLACED_IN_SERVICE
, FIXED_ASSETS_COST
, BOOK_TYPE_CODE
, GROUP_ASSET_ID
, GROUP_ASSET_NUMBER
FROM FA_MASS_ADDITIONS_V
WHERE POSTING_STATUS IN ( 'NEW'
, 'POST'
, 'ON HOLD' )
AND TRANSACTION_TYPE_CODE = 'FUTURE ADD'
AND TRANSACTION_DATE IS NOT NULL
AND ASSET_ID IS NOT NULL

Columns

Name
ROW_ID
ROW_TYPE
ASSET_ID
ASSET_NUMBER
ASSET_KEY_CCID
CURRENT_UNITS
ASSET_TYPE
TAG_NUMBER
DESCRIPTION
ASSET_CATEGORY_ID
PARENT_ASSET_ID
MANUFACTURER_NAME
SERIAL_NUMBER
MODEL_NUMBER
PROPERTY_TYPE_CODE
PROPERTY_1245_1250_CODE
IN_USE_FLAG
OWNED_LEASED
NEW_USED
UNIT_ADJUSTMENT_FLAG
ADD_COST_JE_FLAG
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
ATTRIBUTE26
ATTRIBUTE27
ATTRIBUTE28
ATTRIBUTE29
ATTRIBUTE30
ATTRIBUTE_CATEGORY_CODE
CONTEXT
LEASE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE
LAST_UPDATE_LOGIN
PARENT_ASSET
PARENT_DESCRIPTION
LESSOR
LEASE_NUMBER
LEASE_DESC
LESSOR_ID
LS_ATTRIBUTE1
LS_ATTRIBUTE2
LS_ATTRIBUTE3
LS_ATTRIBUTE4
LS_ATTRIBUTE5
LS_ATTRIBUTE6
LS_ATTRIBUTE7
LS_ATTRIBUTE8
LS_ATTRIBUTE9
LS_ATTRIBUTE10
LS_ATTRIBUTE11
LS_ATTRIBUTE12
LS_ATTRIBUTE13
LS_ATTRIBUTE14
LS_ATTRIBUTE15
LS_ATTRIBUTE_CATEGORY_CODE
CATEGORY_TYPE
CAPITALIZE_FLAG
DATE_PLACED_IN_SERVICE
COST
BOOK_TYPE_CODE
GROUP_ASSET_ID
GROUP_ASSET_NUMBER