View: MTL_DEFAULT_CATEGORY_SETS_FK_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_DEFAULT_CATEGORY_SETS_FK_V

View Text

SELECT DS.ROWID ROW_ID
, DS.FUNCTIONAL_AREA_ID
, ML.MEANING FUNCTIONAL_AREA_DESC
, DS.CATEGORY_SET_ID
, CST.CATEGORY_SET_NAME
, CST.DESCRIPTION CATEGORY_SET_DESCRIPTION
, DS.LAST_UPDATE_DATE
, DS.LAST_UPDATED_BY
, DS.CREATION_DATE
, DS.CREATED_BY
, DS.LAST_UPDATE_LOGIN
, DS.REQUEST_ID
, DS.PROGRAM_APPLICATION_ID
, DS.PROGRAM_ID
, DS.PROGRAM_UPDATE_DATE
FROM MTL_DEFAULT_CATEGORY_SETS DS
, MFG_LOOKUPS ML
, MTL_CATEGORY_SETS_TL CST
WHERE ML.LOOKUP_TYPE = 'MTL_FUNCTIONAL_AREAS'
AND ML.LOOKUP_CODE = DS.FUNCTIONAL_AREA_ID
AND CST.CATEGORY_SET_ID(+) = DS.CATEGORY_SET_ID
AND CST.LANGUAGE(+) = USERENV('LANG')

Columns