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.HZ_CLASS_CATEGORY_GROUPINGS_V

Source

View Text - Preformatted


SELECT CA.CLASS_CODE CATEGORY_GROUP_CODE, CGL.MEANING CATEGORY_GROUP_MEANING, CGL.DESCRIPTION CATEGORY_GROUP_DESCRIPTION, CC.CLASS_CATEGORY, CCL.MEANING CATEGORY_MEANING, CCL.DESCRIPTION CATEGORY_DESCRIPTION, CA.START_DATE_ACTIVE GROUPING_START_DATE, CA.END_DATE_ACTIVE GROUPING_END_DATE, CGL.START_DATE_ACTIVE GROUP_START_DATE, CGL.END_DATE_ACTIVE GROUP_END_DATE, CC.ALLOW_MULTI_ASSIGN_FLAG, CC.ALLOW_MULTI_PARENT_FLAG, CC.ALLOW_LEAF_NODE_ONLY_FLAG, CC.OBJECT_VERSION_NUMBER, CC.DELIMITER, CC.FROZEN_FLAG FROM HZ_CLASS_CATEGORIES CC, HZ_CODE_ASSIGNMENTS CA, FND_LOOKUP_VALUES_VL CGL, FND_LOOKUP_TYPES_VL CCL WHERE CA.CLASS_CATEGORY = 'CLASS_CATEGORY_GROUP' AND CA.OWNER_TABLE_NAME = 'HZ_CLASS_CATEGORIES' AND CA.OWNER_TABLE_KEY_1 = CC.CLASS_CATEGORY AND CGL.LOOKUP_TYPE = 'CLASS_CATEGORY_GROUP' AND CGL.LOOKUP_CODE = CA.CLASS_CODE AND CCL.LOOKUP_TYPE = CA.OWNER_TABLE_KEY_1 AND NVL(CGL.START_DATE_ACTIVE,SYSDATE) <= SYSDATE AND CA.START_DATE_ACTIVE <= SYSDATE AND NVL(CGL.END_DATE_ACTIVE,SYSDATE) >= SYSDATE AND NVL(CA.END_DATE_ACTIVE,SYSDATE) >= SYSDATE

View Text - HTML Formatted

SELECT CA.CLASS_CODE CATEGORY_GROUP_CODE
, CGL.MEANING CATEGORY_GROUP_MEANING
, CGL.DESCRIPTION CATEGORY_GROUP_DESCRIPTION
, CC.CLASS_CATEGORY
, CCL.MEANING CATEGORY_MEANING
, CCL.DESCRIPTION CATEGORY_DESCRIPTION
, CA.START_DATE_ACTIVE GROUPING_START_DATE
, CA.END_DATE_ACTIVE GROUPING_END_DATE
, CGL.START_DATE_ACTIVE GROUP_START_DATE
, CGL.END_DATE_ACTIVE GROUP_END_DATE
, CC.ALLOW_MULTI_ASSIGN_FLAG
, CC.ALLOW_MULTI_PARENT_FLAG
, CC.ALLOW_LEAF_NODE_ONLY_FLAG
, CC.OBJECT_VERSION_NUMBER
, CC.DELIMITER
, CC.FROZEN_FLAG
FROM HZ_CLASS_CATEGORIES CC
, HZ_CODE_ASSIGNMENTS CA
, FND_LOOKUP_VALUES_VL CGL
, FND_LOOKUP_TYPES_VL CCL
WHERE CA.CLASS_CATEGORY = 'CLASS_CATEGORY_GROUP'
AND CA.OWNER_TABLE_NAME = 'HZ_CLASS_CATEGORIES'
AND CA.OWNER_TABLE_KEY_1 = CC.CLASS_CATEGORY
AND CGL.LOOKUP_TYPE = 'CLASS_CATEGORY_GROUP'
AND CGL.LOOKUP_CODE = CA.CLASS_CODE
AND CCL.LOOKUP_TYPE = CA.OWNER_TABLE_KEY_1
AND NVL(CGL.START_DATE_ACTIVE
, SYSDATE) <= SYSDATE
AND CA.START_DATE_ACTIVE <= SYSDATE
AND NVL(CGL.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE
AND NVL(CA.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE