View: ICX_CATEGORY_LOV

Product:	ICX - Oracle iProcurement
Description:	Category LOV View
Implementation/DBA Data:	APPS.ICX_CATEGORY_LOV

View Text

SELECT MCK.CATEGORY_ID
, MCK.CONCATENATED_SEGMENTS
, MCK.DESCRIPTION
, MCK.STRUCTURE_ID
, MCS.CATEGORY_SET_ID
FROM MTL_CATEGORIES_KFV MCK
, MTL_CATEGORY_SETS MCS
WHERE (MCS.VALIDATE_FLAG = 'Y'
AND MCK.CATEGORY_ID IN ( SELECT MCSV.CATEGORY_ID
FROM MTL_CATEGORY_SET_VALID_CATS MCSV
WHERE MCSV.CATEGORY_SET_ID = MCS.CATEGORY_SET_ID) ) OR (MCS.VALIDATE_FLAG <> 'Y'
AND MCS.STRUCTURE_ID = MCK.STRUCTURE_ID)

Columns