VIEW: APPS.AMS_MTL_CATEGORIES_DENORM_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID , B.CATEGORY_ID , B.STRUCTURE_ID , B.concatenated_ids, t.concatenated_description FROM AMS_MTL_CATEGORIES_DENORM_TL T , AMS_MTL_CATEGORIES_DENORM_B B WHERE B.CATEGORY_ID = T.CATEGORY_ID AND T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.CATEGORY_ID
, B.STRUCTURE_ID
, B.CONCATENATED_IDS
, T.CONCATENATED_DESCRIPTION
FROM AMS_MTL_CATEGORIES_DENORM_TL T
, AMS_MTL_CATEGORIES_DENORM_B B
WHERE B.CATEGORY_ID = T.CATEGORY_ID
AND T.LANGUAGE = USERENV('LANG')