View: CSC_PROF_CATEGORY_LOOKUPS_V

Product:	CSC - Customer Care
Description:	View joining csc_prof_group_categories and csc_lookups
Implementation/DBA Data:	APPS.CSC_PROF_CATEGORY_LOOKUPS_V

View Text

SELECT CPGC.ROWID ROW_ID
, CPGC.GROUP_CATEGORY_ID GROUP_CATEGORY_ID
, CPGC.GROUP_ID GROUP_ID
, CPGC.CATEGORY_CODE CATEGORY_CODE
, CPGC.CATEGORY_SEQUENCE CATEGORY_SEQUENCE
, LK.MEANING MEANING FROM CSC_PROF_GROUP_CATEGORIES CPGC
, CSC_LOOKUPS LK WHERE LK.LOOKUP_TYPE = 'CSC_PROF_CATEGORIES' AND CPGC.CATEGORY_CODE = LK.LOOKUP_CODE

Columns