VIEW: APPS.OKX_CATEGORY_SETS_V

Source

View Text - Preformatted

SELECT B.CATEGORY_SET_ID ID1, '#' ID2, T.CATEGORY_SET_NAME NAME, B.VALIDATE_FLAG B_STATUS, DECODE(B.VALIDATE_FLAG,'Y','A', 'I') STATUS, T.DESCRIPTION DESCRIPTION, B.STRUCTURE_ID STRUCTURE_ID, SYSDATE START_DATE_ACTIVE, DECODE(B.VALIDATE_FLAG, 'N', SYSDATE) END_DATE_ACTIVE FROM MTL_CATEGORY_SETS_B B,MTL_CATEGORY_SETS_TL T WHERE B.CATEGORY_SET_ID = T.CATEGORY_SET_ID AND T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.CATEGORY_SET_ID ID1
, '#' ID2
, T.CATEGORY_SET_NAME NAME
, B.VALIDATE_FLAG B_STATUS
, DECODE(B.VALIDATE_FLAG
, 'Y'
, 'A'
, 'I') STATUS
, T.DESCRIPTION DESCRIPTION
, B.STRUCTURE_ID STRUCTURE_ID
, SYSDATE START_DATE_ACTIVE
, DECODE(B.VALIDATE_FLAG
, 'N'
, SYSDATE) END_DATE_ACTIVE
FROM MTL_CATEGORY_SETS_B B
, MTL_CATEGORY_SETS_TL T
WHERE B.CATEGORY_SET_ID = T.CATEGORY_SET_ID
AND T.LANGUAGE = USERENV('LANG')