eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ICX_REQ_CATEGORIES_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'