DBA Data[Home] [Help]

VIEW: APPS.IC_FRGT_CLS_VW

Source

View Text - Preformatted

SELECT substrb(c.CATEGORY_CONCAT_SEGS,1,8), c.CATEGORY_ID, substrb(c.DESCRIPTION,1,70), c.CREATION_DATE, c.LAST_UPDATE_DATE, c.CREATED_BY, c.LAST_UPDATED_BY, 0, decode(c.DISABLE_DATE, NULL, 0, 1), to_number(NULL), 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 from mtl_categories_v c, mtl_category_sets cs, gmi_category_sets ocs WHERE ocs.OPM_CLASS = 'FRT_CLASS' and ocs.CATEGORY_SET_ID = cs.CATEGORY_SET_ID and cs.STRUCTURE_ID = c.STRUCTURE_ID and c.CATEGORY_CONCAT_SEGS = upper(substrb(c.CATEGORY_CONCAT_SEGS,1,8)) AND cs.validate_flag <> 'Y' UNION SELECT SUBSTRB (c.category_concat_segs, 1, 8), c.category_id, SUBSTRB (c.description, 1, 70), c.creation_date, c.last_update_date, c.created_by, c.last_updated_by, 0, DECODE (c.disable_date, NULL, 0, 1), TO_NUMBER (NULL), 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 FROM mtl_categories_v c, mtl_category_sets cs, gmi_category_sets ocs, mtl_category_set_valid_cats csvc WHERE ocs.opm_class = 'FRT_CLASS' AND ocs.category_set_id = cs.category_set_id AND cs.structure_id = c.structure_id AND c.category_concat_segs = UPPER (SUBSTRB (c.category_concat_segs, 1, 8)) 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 SUBSTRB(C.CATEGORY_CONCAT_SEGS
, 1
, 8)
, C.CATEGORY_ID
, SUBSTRB(C.DESCRIPTION
, 1
, 70)
, C.CREATION_DATE
, C.LAST_UPDATE_DATE
, C.CREATED_BY
, C.LAST_UPDATED_BY
, 0
, DECODE(C.DISABLE_DATE
, NULL
, 0
, 1)
, TO_NUMBER(NULL)
, 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
FROM MTL_CATEGORIES_V C
, MTL_CATEGORY_SETS CS
, GMI_CATEGORY_SETS OCS
WHERE OCS.OPM_CLASS = 'FRT_CLASS'
AND OCS.CATEGORY_SET_ID = CS.CATEGORY_SET_ID
AND CS.STRUCTURE_ID = C.STRUCTURE_ID
AND C.CATEGORY_CONCAT_SEGS = UPPER(SUBSTRB(C.CATEGORY_CONCAT_SEGS
, 1
, 8))
AND CS.VALIDATE_FLAG <> 'Y' UNION SELECT SUBSTRB (C.CATEGORY_CONCAT_SEGS
, 1
, 8)
, C.CATEGORY_ID
, SUBSTRB (C.DESCRIPTION
, 1
, 70)
, C.CREATION_DATE
, C.LAST_UPDATE_DATE
, C.CREATED_BY
, C.LAST_UPDATED_BY
, 0
, DECODE (C.DISABLE_DATE
, NULL
, 0
, 1)
, TO_NUMBER (NULL)
, 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
FROM MTL_CATEGORIES_V C
, MTL_CATEGORY_SETS CS
, GMI_CATEGORY_SETS OCS
, MTL_CATEGORY_SET_VALID_CATS CSVC
WHERE OCS.OPM_CLASS = 'FRT_CLASS'
AND OCS.CATEGORY_SET_ID = CS.CATEGORY_SET_ID
AND CS.STRUCTURE_ID = C.STRUCTURE_ID
AND C.CATEGORY_CONCAT_SEGS = UPPER (SUBSTRB (C.CATEGORY_CONCAT_SEGS
, 1
, 8))
AND CS.VALIDATE_FLAG = 'Y'
AND CS.CATEGORY_SET_ID = CSVC.CATEGORY_SET_ID
AND C.CATEGORY_ID = CSVC.CATEGORY_ID