VIEW: APPS.FA_ADDITIONS_WEB_V

Source

View Text - Preformatted

SELECT AD.ROWID ROW_ID , AD.ASSET_ID , AD.ASSET_NUMBER , AD.ASSET_KEY_CCID , AK.CONCATENATED_SEGMENTS ASSET_KEY , CK.CONCATENATED_SEGMENTS CATEGORY , 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 , LU1.MEANING PROPERTY_TYPE_CODE , AD.PROPERTY_1245_1250_CODE , LU2.MEANING IN_USE_FLAG , LU3.MEANING 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 FROM FA_ADDITIONS AD, FA_ADDITIONS PAD, FA_LOOKUPS LU1, FA_LOOKUPS LU2, FA_LOOKUPS LU3, FA_LEASES LEASE, PO_VENDORS PV, FA_ASSET_KEYWORDS_KFV AK, FA_CATEGORIES_B_KFV CK, FA_CATEGORIES_B CA WHERE AD.PARENT_ASSET_ID = PAD.ASSET_ID(+) AND AD.LEASE_ID = LEASE.LEASE_ID(+) AND PV.VENDOR_ID(+) = LEASE.LESSOR_ID AND (LU1.LOOKUP_TYPE(+) = 'PROPERTY TYPE' AND LU1.LOOKUP_CODE(+) = AD.PROPERTY_TYPE_CODE) AND (LU2.LOOKUP_TYPE = 'YESNO' AND LU2.LOOKUP_CODE = AD.IN_USE_FLAG) AND (LU3.LOOKUP_TYPE = 'OWNLEASE' AND LU3.LOOKUP_CODE = AD.OWNED_LEASED) 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(+)

View Text - HTML Formatted

SELECT AD.ROWID ROW_ID
, AD.ASSET_ID
, AD.ASSET_NUMBER
, AD.ASSET_KEY_CCID
, AK.CONCATENATED_SEGMENTS ASSET_KEY
, CK.CONCATENATED_SEGMENTS CATEGORY
, 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
, LU1.MEANING PROPERTY_TYPE_CODE
, AD.PROPERTY_1245_1250_CODE
, LU2.MEANING IN_USE_FLAG
, LU3.MEANING 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
FROM FA_ADDITIONS AD
, FA_ADDITIONS PAD
, FA_LOOKUPS LU1
, FA_LOOKUPS LU2
, FA_LOOKUPS LU3
, FA_LEASES LEASE
, PO_VENDORS PV
, FA_ASSET_KEYWORDS_KFV AK
, FA_CATEGORIES_B_KFV CK
, FA_CATEGORIES_B CA
WHERE AD.PARENT_ASSET_ID = PAD.ASSET_ID(+)
AND AD.LEASE_ID = LEASE.LEASE_ID(+)
AND PV.VENDOR_ID(+) = LEASE.LESSOR_ID
AND (LU1.LOOKUP_TYPE(+) = 'PROPERTY TYPE'
AND LU1.LOOKUP_CODE(+) = AD.PROPERTY_TYPE_CODE)
AND (LU2.LOOKUP_TYPE = 'YESNO'
AND LU2.LOOKUP_CODE = AD.IN_USE_FLAG)
AND (LU3.LOOKUP_TYPE = 'OWNLEASE'
AND LU3.LOOKUP_CODE = AD.OWNED_LEASED)
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(+)