View: HZ_CLASS_CATEGORY_GROUPINGS_V

Product:	AR - Receivables
Description:	Classification Category Groupings
Implementation/DBA Data:	APPS.HZ_CLASS_CATEGORY_GROUPINGS_V

View Text

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

Columns