[Home] [Help]
View: OKX_CATEGORIES_V
Product: | OKX - Contracts Integration |
Description: | Item categories |
Implementation/DBA Data: |
APPS.OKX_CATEGORIES_V
|
View Text
SELECT BK.CATEGORY_ID ID1
, '#' ID2
, BK.STRUCTURE_ID STRUCTURE_ID
, T.DESCRIPTION NAME
, NULL PRIMARY_UOM_CODE
, BK.ENABLED_FLAG B_STATUS
, DECODE(BK.ENABLED_FLAG
, 'Y'
, CASE WHEN (TRUNC(NVL(DISABLE_DATE
, SYSDATE+1))<=TRUNC(SYSDATE)) THEN 'I' ELSE 'A' END
, 'I') STATUS
, BK.CONCATENATED_SEGMENTS DESCRIPTION
, BK.START_DATE_ACTIVE START_DATE_ACTIVE
, BK.END_DATE_ACTIVE END_DATE_ACTIVE
FROM MTL_CATEGORIES_TL T
, MTL_CATEGORIES_B_KFV BK
WHERE BK.CATEGORY_ID = T.CATEGORY_ID
AND T.LANGUAGE = USERENV('LANG')
Columns
Name |
ID1 |
ID2 |
STRUCTURE_ID |
NAME |
PRIMARY_UOM_CODE |
B_STATUS |
STATUS |
DESCRIPTION |
START_DATE_ACTIVE |
END_DATE_ACTIVE |