View: MTL_DEFAULT_SETS_VIEW

Product:	INV - Inventory
Description:	Required to get around SRS's 240 char limit when defaulting category sets
Implementation/DBA Data:	APPS.MTL_DEFAULT_SETS_VIEW

View Text

SELECT S.CATEGORY_SET_ID
, ST.CATEGORY_SET_NAME
, ST.DESCRIPTION
, S.STRUCTURE_ID
, S.VALIDATE_FLAG
, D.FUNCTIONAL_AREA_ID
FROM MTL_CATEGORY_SETS_TL ST
, MTL_CATEGORY_SETS_B S
, MTL_DEFAULT_CATEGORY_SETS D
WHERE S.CATEGORY_SET_ID = ST.CATEGORY_SET_ID
AND ST.LANGUAGE = USERENV('LANG')
AND D.CATEGORY_SET_ID = S.CATEGORY_SET_ID

Columns