View: IC_ITEM_HIERARCHY_V

Product:	GMI - Process Manufacturing Inventory
Description:	Used by Item Activation Workflow
Implementation/DBA Data:	APPS.IC_ITEM_HIERARCHY_V

View Text

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

Columns