A view that joins HZ_CLASS_CATEGORIES with FND_LOOKUP_TYPES_TL to include the descriptive class category meaning for the current session language.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT CLASS_CATEGORY , MEANING FROM HZ_CLASS_CATEGORIES C , FND_LOOKUP_TYPES_TL L WHERE C.CLASS_CATEGORY = L.LOOKUP_TYPE AND C.ALLOW_MULTI_PARENT_FLAG ='N' AND C.ALLOW_MULTI_ASSIGN_FLAG = 'N' AND CLASS_CATEGORY NOT IN( SELECT B.CLASS_CATEGORY FROM HZ_CLASS_CATEGORIES C , HZ_CLASS_CODE_RELATIONS B WHERE C.CLASS_CATEGORY = L.LOOKUP_TYPE AND B.CLASS_CATEGORY = L.LOOKUP_TYPE AND B.START_DATE_ACTIVE <= SYSDATE AND NVL(B.END_DATE_ACTIVE , SYSDATE+1) > SYSDATE) AND L.VIEW_APPLICATION_ID = 222 AND L.LANGUAGE = USERENV('LANG') AND CLASS_CATEGORY IN (SELECT OWNER_TABLE_KEY_1 FROM HZ_CODE_ASSIGNMENTS WHERE OWNER_TABLE_NAME = 'HZ_CLASS_CATEGORIES' AND CLASS_CATEGORY = 'CLASS_CATEGORY_GROUP' AND CLASS_CODE = 'ORG_GROUP') UNION ALL SELECT C.CLASS_CATEGORY , MEANING FROM HZ_CLASS_CATEGORIES C , FND_LOOKUP_TYPES_TL L , HZ_CLASS_CATEGORY_USES CU WHERE C.CLASS_CATEGORY = CU.CLASS_CATEGORY AND ( UPPER(CU.ADDITIONAL_WHERE_CLAUSE) LIKE DECODE('ORG_GROUP' , 'ORG_GROUP' , '%PARTY_TYPE%ORGANIZATION%' , 'PERSON_GROUP' , '%PARTY_TYPE%PERSON%' , '%') OR CU.ADDITIONAL_WHERE_CLAUSE IS NULL OR UPPER(CU.ADDITIONAL_WHERE_CLAUSE) LIKE '%WHERE 1=1%' ) AND CU.OWNER_TABLE = 'HZ_PARTIES' AND C.CLASS_CATEGORY = L.LOOKUP_TYPE AND C.ALLOW_MULTI_PARENT_FLAG ='N' AND C.ALLOW_MULTI_ASSIGN_FLAG = 'N' AND C.CLASS_CATEGORY NOT IN( SELECT B.CLASS_CATEGORY FROM HZ_CLASS_CATEGORIES C , HZ_CLASS_CODE_RELATIONS B WHERE C.CLASS_CATEGORY = L.LOOKUP_TYPE AND B.CLASS_CATEGORY = L.LOOKUP_TYPE AND B.START_DATE_ACTIVE <= SYSDATE AND NVL(B.END_DATE_ACTIVE , SYSDATE+1) > SYSDATE) AND L.VIEW_APPLICATION_ID = 222 AND L.LANGUAGE = USERENV('LANG') AND C.CLASS_CATEGORY NOT IN (SELECT OWNER_TABLE_KEY_1 FROM HZ_CODE_ASSIGNMENTS WHERE OWNER_TABLE_NAME = 'HZ_CLASS_CATEGORIES') AND C.CLASS_CATEGORY NOT IN ( 'RELATIONSHIP_TYPE_GROUP' , 'CLASS_CATEGORY_GROUP')