VIEW: APPS.MTL_DEFAULT_CATEGORY_SETS_FK_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')