VIEW: APPS.CR_SQDT_CLS_VW

Source

View Text - Preformatted

SELECT c.CATEGORY_CONCAT_SEGS, c.CATEGORY_ID, c.DESCRIPTION, 0, DECODE(c.DISABLE_DATE, NULL, 0, 1), TO_NUMBER(NULL), c.CREATION_DATE, c.CREATED_BY, c.LAST_UPDATE_DATE, c.LAST_UPDATED_BY, c.LAST_UPDATE_LOGIN FROM mtl_categories_v c, mtl_category_sets cs, MTL_DEFAULT_CATEGORY_SETS DCS WHERE DCS.FUNCTIONAL_AREA_ID = 14 AND DCS.CATEGORY_SET_ID = CS.CATEGORY_SET_ID AND CS.STRUCTURE_ID = C.STRUCTURE_ID AND C.CATEGORY_CONCAT_SEGS = C.CATEGORY_CONCAT_SEGS AND CS.VALIDATE_FLAG <> 'Y' UNION SELECT C.CATEGORY_CONCAT_SEGS, C.CATEGORY_ID, C.DESCRIPTION, 0, DECODE(C.DISABLE_DATE,NULL,0, 1), TO_NUMBER(NULL), C.CREATION_DATE, C.CREATED_BY, C.LAST_UPDATE_DATE, C.LAST_UPDATED_BY, C.LAST_UPDATE_LOGIN FROM MTL_CATEGORIES_V C, MTL_CATEGORY_SETS CS, MTL_DEFAULT_CATEGORY_SETS DCS, MTL_CATEGORY_SET_VALID_CATS CSVC WHERE DCS.FUNCTIONAL_AREA_ID = 14 AND DCS.CATEGORY_SET_ID = CS.CATEGORY_SET_ID AND CS.STRUCTURE_ID = C.STRUCTURE_ID AND C.CATEGORY_CONCAT_SEGS = C.CATEGORY_CONCAT_SEGS AND CS.VALIDATE_FLAG = 'Y' AND CS.CATEGORY_SET_ID = CSVC.CATEGORY_SET_ID AND C.CATEGORY_ID = CSVC.CATEGORY_ID

View Text - HTML Formatted

SELECT C.CATEGORY_CONCAT_SEGS
, C.CATEGORY_ID
, C.DESCRIPTION
, 0
, DECODE(C.DISABLE_DATE
, NULL
, 0
, 1)
, TO_NUMBER(NULL)
, C.CREATION_DATE
, C.CREATED_BY
, C.LAST_UPDATE_DATE
, C.LAST_UPDATED_BY
, C.LAST_UPDATE_LOGIN
FROM MTL_CATEGORIES_V C
, MTL_CATEGORY_SETS CS
, MTL_DEFAULT_CATEGORY_SETS DCS
WHERE DCS.FUNCTIONAL_AREA_ID = 14
AND DCS.CATEGORY_SET_ID = CS.CATEGORY_SET_ID
AND CS.STRUCTURE_ID = C.STRUCTURE_ID
AND C.CATEGORY_CONCAT_SEGS = C.CATEGORY_CONCAT_SEGS
AND CS.VALIDATE_FLAG <> 'Y' UNION SELECT C.CATEGORY_CONCAT_SEGS
, C.CATEGORY_ID
, C.DESCRIPTION
, 0
, DECODE(C.DISABLE_DATE
, NULL
, 0
, 1)
, TO_NUMBER(NULL)
, C.CREATION_DATE
, C.CREATED_BY
, C.LAST_UPDATE_DATE
, C.LAST_UPDATED_BY
, C.LAST_UPDATE_LOGIN
FROM MTL_CATEGORIES_V C
, MTL_CATEGORY_SETS CS
, MTL_DEFAULT_CATEGORY_SETS DCS
, MTL_CATEGORY_SET_VALID_CATS CSVC
WHERE DCS.FUNCTIONAL_AREA_ID = 14
AND DCS.CATEGORY_SET_ID = CS.CATEGORY_SET_ID
AND CS.STRUCTURE_ID = C.STRUCTURE_ID
AND C.CATEGORY_CONCAT_SEGS = C.CATEGORY_CONCAT_SEGS
AND CS.VALIDATE_FLAG = 'Y'
AND CS.CATEGORY_SET_ID = CSVC.CATEGORY_SET_ID
AND C.CATEGORY_ID = CSVC.CATEGORY_ID