VIEW: APPS.BIS_OBJ_HIERARCHY_V

Source

View Text - Preformatted

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(+)
   

View Text - HTML Formatted

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(+)