View: BIS_OBJ_HIERARCHY_V

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BIS_OBJ_HIERARCHY_V

View Text

SELECT OBJECTS.OBJ_TYPE
, OBJECTS.OBJ_NAME
, DECODE(OBJECTS.OBJ_TYPE
, 'PORTLET'
, FUNC.USER_FUNCTION_NAME
, 'REPORT'
, FUNC.USER_FUNCTION_NAME
, OBJECTS.OBJ_NAME) USER_OBJ_NAME
, PROGRAMS.USER_CONCURRENT_PROGRAM_NAME USER_CONCURRENT_PROGRAM_NAME
, LINKAGES.REFRESH_MODE
, LOOKUPS.MEANING OBJ_DISP_TYPE
FROM ( SELECT OBJECT_TYPE OBJ_TYPE
, OBJECT_NAME OBJ_NAME
FROM BIS_OBJ_DEPENDENCY UNION SELECT DEPEND_OBJECT_TYPE OBJ_TYPE
, DEPEND_OBJECT_NAME OBJ_NAME
FROM BIS_OBJ_DEPENDENCY ) OBJECTS
, BIS_OBJ_PROG_LINKAGES LINKAGES
, FND_CONCURRENT_PROGRAMS_VL PROGRAMS
, FND_COMMON_LOOKUPS LOOKUPS
, FND_FORM_FUNCTIONS_VL FUNC
WHERE OBJECTS.OBJ_TYPE=LINKAGES.OBJECT_TYPE(+)
AND OBJECTS.OBJ_NAME=LINKAGES.OBJECT_NAME(+)
AND LINKAGES.CONC_APP_ID = PROGRAMS.APPLICATION_ID(+)
AND LINKAGES.CONC_PROGRAM_NAME = PROGRAMS.CONCURRENT_PROGRAM_NAME(+)
AND OBJECTS.OBJ_TYPE = LOOKUPS.LOOKUP_CODE
AND LOOKUPS.LOOKUP_TYPE = 'BIS_OBJECT_TYPE'
AND OBJECTS.OBJ_NAME = FUNC.FUNCTION_NAME(+)