View: CST_ACTIVITIES_V

Product:	BOM - Bills of Material
Description:	Activities : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_ACTIVITIES_V

View Text

SELECT CA.ROWID
, CA.ACTIVITY_ID
, CA.LAST_UPDATE_DATE
, CA.LAST_UPDATED_BY
, CA.CREATION_DATE
, CA.CREATED_BY
, CA.LAST_UPDATE_LOGIN
, CA.ACTIVITY
, CA.ORGANIZATION_ID
, DECODE(CA.ORGANIZATION_ID
, NULL
, 1
, 2)
, CA.DESCRIPTION
, CA.DEFAULT_BASIS_TYPE
, BASIS.MEANING
, CA.DISABLE_DATE
, CA.OUTPUT_UOM
, CA.VALUE_ADDED_ACTIVITY_FLAG
, CA.ATTRIBUTE_CATEGORY
, CA.ATTRIBUTE1
, CA.ATTRIBUTE2
, CA.ATTRIBUTE3
, CA.ATTRIBUTE4
, CA.ATTRIBUTE5
, CA.ATTRIBUTE6
, CA.ATTRIBUTE7
, CA.ATTRIBUTE8
, CA.ATTRIBUTE9
, CA.ATTRIBUTE10
, CA.ATTRIBUTE11
, CA.ATTRIBUTE12
, CA.ATTRIBUTE13
, CA.ATTRIBUTE14
, CA.ATTRIBUTE15
FROM CST_ACTIVITIES CA
, MFG_LOOKUPS BASIS
WHERE BASIS.LOOKUP_TYPE (+) = 'CST_BASIS'
AND BASIS.LOOKUP_CODE (+) = CA.DEFAULT_BASIS_TYPE

Columns