Product: | GMI - Process Manufacturing Inventory |
---|---|
Description: | Technical Class Subclass View |
Implementation/DBA Data: | APPS.TECH_CLS_SUBCLS_VW |
SELECT C.CATEGORY_CONCAT_SEGS
, C.CATEGORY_ID
, C.DESCRIPTION
, TO_NUMBER(NULL)
, 0
, DECODE(C.DISABLE_DATE
, NULL
, 0
, 1)
, C.CREATED_BY
, C.CREATION_DATE
, C.LAST_UPDATED_BY
, C.LAST_UPDATE_DATE
, C.LAST_UPDATE_LOGIN
, C.ATTRIBUTE1
, C.ATTRIBUTE2
, C.ATTRIBUTE3
, C.ATTRIBUTE4
, C.ATTRIBUTE5
, C.ATTRIBUTE6
, C.ATTRIBUTE7
, C.ATTRIBUTE8
, C.ATTRIBUTE9
, C.ATTRIBUTE10
, C.ATTRIBUTE11
, C.ATTRIBUTE12
, C.ATTRIBUTE13
, C.ATTRIBUTE14
, C.ATTRIBUTE15
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, C.ATTRIBUTE_CATEGORY
, TO_CHAR(NULL)
FROM MTL_CATEGORIES_V C
, MTL_CATEGORY_SETS CS
, GMI_CATEGORY_SETS OCS
WHERE OCS.OPM_CLASS = 'TECH_CLASS'
AND OCS.CATEGORY_SET_ID = CS.CATEGORY_SET_ID
AND CS.STRUCTURE_ID = C.STRUCTURE_ID
AND CS.VALIDATE_FLAG <> 'Y' UNION SELECT C.CATEGORY_CONCAT_SEGS
, C.CATEGORY_ID
, C.DESCRIPTION
, TO_NUMBER (NULL)
, 0
, DECODE (C.DISABLE_DATE
, NULL
, 0
, 1)
, C.CREATED_BY
, C.CREATION_DATE
, C.LAST_UPDATED_BY
, C.LAST_UPDATE_DATE
, C.LAST_UPDATE_LOGIN
, C.ATTRIBUTE1
, C.ATTRIBUTE2
, C.ATTRIBUTE3
, C.ATTRIBUTE4
, C.ATTRIBUTE5
, C.ATTRIBUTE6
, C.ATTRIBUTE7
, C.ATTRIBUTE8
, C.ATTRIBUTE9
, C.ATTRIBUTE10
, C.ATTRIBUTE11
, C.ATTRIBUTE12
, C.ATTRIBUTE13
, C.ATTRIBUTE14
, C.ATTRIBUTE15
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, C.ATTRIBUTE_CATEGORY
, TO_CHAR (NULL)
FROM MTL_CATEGORIES_V C
, MTL_CATEGORY_SETS CS
, GMI_CATEGORY_SETS OCS
, MTL_CATEGORY_SET_VALID_CATS CSVC
WHERE OCS.OPM_CLASS = 'TECH_CLASS'
AND OCS.CATEGORY_SET_ID = CS.CATEGORY_SET_ID
AND CS.STRUCTURE_ID = C.STRUCTURE_ID
AND CS.VALIDATE_FLAG = 'Y'
AND CS.CATEGORY_SET_ID = CSVC.CATEGORY_SET_ID
AND C.CATEGORY_ID = CSVC.CATEGORY_ID