VIEW: APPS.IC_TAXN_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 from mtl_categories_v c, mtl_category_sets cs, gmi_category_sets ocs WHERE ocs.OPM_CLASS = 'TAX_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))

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
FROM MTL_CATEGORIES_V C
, MTL_CATEGORY_SETS CS
, GMI_CATEGORY_SETS OCS
WHERE OCS.OPM_CLASS = 'TAX_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))