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