VIEW: APPS.CN_COMP_GROUPS_V

Source

View Text - Preformatted

SELECT ccgh.comp_group_id, ccg1.name name, ccgh.parent_comp_group_id, ccg2.name parent_name, ccgh.start_date_active, ccgh.end_date_active from cn_comp_group_hier ccgh, cn_comp_groups ccg1, cn_comp_groups ccg2 WHERE ccgh.comp_group_id = ccg1.comp_group_id and ccgh.parent_comp_group_id = ccg2.comp_group_id(+)

View Text - HTML Formatted

SELECT CCGH.COMP_GROUP_ID
, CCG1.NAME NAME
, CCGH.PARENT_COMP_GROUP_ID
, CCG2.NAME PARENT_NAME
, CCGH.START_DATE_ACTIVE
, CCGH.END_DATE_ACTIVE
FROM CN_COMP_GROUP_HIER CCGH
, CN_COMP_GROUPS CCG1
, CN_COMP_GROUPS CCG2
WHERE CCGH.COMP_GROUP_ID = CCG1.COMP_GROUP_ID
AND CCGH.PARENT_COMP_GROUP_ID = CCG2.COMP_GROUP_ID(+)