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: CST_XLA_ACTIVITY_REF_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_XLA_ACTIVITY_REF_V

View Text

SELECT ACTIVITY_ID
, ACTIVITY ACTIVITY_NAME
, DESCRIPTION ACTIVITY_DESCRIPTION
, OUTPUT_UOM ACTIVITY_OUTPUT_UOM
, DECODE(VALUE_ADDED_ACTIVITY_FLAG
, 'YES'
, 'Y'
, 'N' )VALUE_ADDED_ACTIVITY_FLAG
, ATTRIBUTE_CATEGORY ACTIVITY_ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ACTIVITY_ATTRIBUTE1
, ATTRIBUTE2 ACTIVITY_ATTRIBUTE2
, ATTRIBUTE3 ACTIVITY_ATTRIBUTE3
, ATTRIBUTE4 ACTIVITY_ATTRIBUTE4
, ATTRIBUTE5 ACTIVITY_ATTRIBUTE5
, ATTRIBUTE6 ACTIVITY_ATTRIBUTE6
, ATTRIBUTE7 ACTIVITY_ATTRIBUTE7
, ATTRIBUTE8 ACTIVITY_ATTRIBUTE8
, ATTRIBUTE9 ACTIVITY_ATTRIBUTE9
, ATTRIBUTE10 ACTIVITY_ATTRIBUTE10
, ATTRIBUTE11 ACTIVITY_ATTRIBUTE11
, ATTRIBUTE12 ACTIVITY_ATTRIBUTE12
, ATTRIBUTE13 ACTIVITY_ATTRIBUTE13
, ATTRIBUTE14 ACTIVITY_ATTRIBUTE14
, ATTRIBUTE15 ACTIVITY_ATTRIBUTE15
FROM CST_ACTIVITIES

Columns

Name
ACTIVITY_ID
ACTIVITY_NAME
ACTIVITY_DESCRIPTION
ACTIVITY_OUTPUT_UOM
VALUE_ADDED_ACTIVITY_FLAG
ACTIVITY_ATTRIBUTE_CATEGORY
ACTIVITY_ATTRIBUTE1
ACTIVITY_ATTRIBUTE2
ACTIVITY_ATTRIBUTE3
ACTIVITY_ATTRIBUTE4
ACTIVITY_ATTRIBUTE5
ACTIVITY_ATTRIBUTE6
ACTIVITY_ATTRIBUTE7
ACTIVITY_ATTRIBUTE8
ACTIVITY_ATTRIBUTE9
ACTIVITY_ATTRIBUTE10
ACTIVITY_ATTRIBUTE11
ACTIVITY_ATTRIBUTE12
ACTIVITY_ATTRIBUTE13
ACTIVITY_ATTRIBUTE14
ACTIVITY_ATTRIBUTE15