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.

VIEW: APPS.CST_XLA_ACTIVITY_REF_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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