[Home] [Help]
View: OKX_CATEGORY_SETS_V
View Text
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')
Columns
Name |
ID1 |
ID2 |
NAME |
B_STATUS |
STATUS |
DESCRIPTION |
STRUCTURE_ID |
START_DATE_ACTIVE |
END_DATE_ACTIVE |