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_DEPARTMENT_REF_V

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

View Text

SELECT DEPARTMENT_ID
, DEPARTMENT_CODE
, DESCRIPTION
, DEPARTMENT_CLASS_CODE
, MAINT_COST_CATEGORY
, LOCATION_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM BOM_DEPARTMENTS

Columns

Name
DEPT_ID
DEPT_CODE
DEPT_DESCRIPTION
DEPT_CLASS_CODE
DEPT_MAINT_COST_CAT
DEPT_LOCATION_ID
DEPT_ATTRIBUTE_CATEGORY
DEPT_ATTRIBUTE1
DEPT_ATTRIBUTE2
DEPT_ATTRIBUTE3
DEPT_ATTRIBUTE4
DEPT_ATTRIBUTE5
DEPT_ATTRIBUTE6
DEPT_ATTRIBUTE7
DEPT_ATTRIBUTE8
DEPT_ATTRIBUTE9
DEPT_ATTRIBUTE10
DEPT_ATTRIBUTE11
DEPT_ATTRIBUTE12
DEPT_ATTRIBUTE13
DEPT_ATTRIBUTE14
DEPT_ATTRIBUTE15