VIEW: APPS.IC_ITEM_HIERARCHY_V

Source

View Text - Preformatted

SELECT b.user_name creator_user_name,c.user_name supervisor_user_name FROM per_assignments_f a,fnd_user b,fnd_user c WHERE a.person_id = b.employee_id AND a.supervisor_id= c.employee_id AND 'HRMS' = (select meaning from gem_lookups where lookup_type='IC_ITEM_HIERARCHY' AND lookup_code='1') group by b.user_name,c.user_name UNION SELECT creator_user_name,supervisor_user_name FROM IC_ITEM_HIERARCHY WHERE 'OPM' = (select meaning from gem_lookups where lookup_type='IC_ITEM_HIERARCHY' AND lookup_code='1')

View Text - HTML Formatted

SELECT B.USER_NAME CREATOR_USER_NAME
, C.USER_NAME SUPERVISOR_USER_NAME
FROM PER_ASSIGNMENTS_F A
, FND_USER B
, FND_USER C
WHERE A.PERSON_ID = B.EMPLOYEE_ID
AND A.SUPERVISOR_ID= C.EMPLOYEE_ID
AND 'HRMS' = (SELECT MEANING
FROM GEM_LOOKUPS
WHERE LOOKUP_TYPE='IC_ITEM_HIERARCHY'
AND LOOKUP_CODE='1') GROUP BY B.USER_NAME
, C.USER_NAME UNION SELECT CREATOR_USER_NAME
, SUPERVISOR_USER_NAME
FROM IC_ITEM_HIERARCHY
WHERE 'OPM' = (SELECT MEANING
FROM GEM_LOOKUPS
WHERE LOOKUP_TYPE='IC_ITEM_HIERARCHY'
AND LOOKUP_CODE='1')