VIEW: APPS.FII_PARTY_MKT_CLASS_TYPE_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')