View: ICX_REQ_CATEGORIES_V

Product:	ICX - Oracle iProcurement
Description:	Categories View
Implementation/DBA Data:	APPS.ICX_REQ_CATEGORIES_V

View Text

SELECT MCK.DESCRIPTION DESCRIPTION
, MCK.CATEGORY_ID CATEGORY_ID
, MCK.CONCATENATED_SEGMENTS CATEGORY_NAME
, MDSV. FUNCTIONAL_AREA_ID FUNCTIONAL_AREA_ID
FROM MTL_CATEGORIES_KFV MCK
, MTL_CATEGORY_SET_VALID_CATS MCSVC
, MTL_DEFAULT_SETS_VIEW MDSV
WHERE MCSVC.CATEGORY_SET_ID = MDSV.CATEGORY_SET_ID
AND MCSVC.CATEGORY_ID = MCK.CATEGORY_ID
AND MCK.STRUCTURE_ID = MDSV.STRUCTURE_ID
AND MCK.ATTRIBUTE10 = 'Y'
AND NVL(MCK.START_DATE_ACTIVE
, SYSDATE) <= SYSDATE
AND SYSDATE < NVL(MCK.END_DATE_ACTIVE
, SYSDATE+1)
AND SYSDATE < NVL(MCK.DISABLE_DATE
, SYSDATE+1)
AND MDSV.VALIDATE_FLAG = 'Y' UNION SELECT MCK.DESCRIPTION DESCRIPTION
, MCK.CATEGORY_ID CATEGORY_ID
, MCK.CONCATENATED_SEGMENTS CATEGORY_NAME
, MDSV.FUNCTIONAL_AREA_ID FUNCTIONAL_AREA_ID
FROM MTL_CATEGORIES_KFV MCK
, MTL_DEFAULT_SETS_VIEW MDSV
WHERE MCK.STRUCTURE_ID = MDSV.STRUCTURE_ID
AND MCK.ATTRIBUTE10 = 'Y'
AND NVL(MCK.START_DATE_ACTIVE
, SYSDATE) <= SYSDATE
AND SYSDATE < NVL(MCK.END_DATE_ACTIVE
, SYSDATE+1)
AND SYSDATE < NVL(MCK.DISABLE_DATE
, SYSDATE+1)
AND MDSV.VALIDATE_FLAG <> 'Y'

Columns