VIEW: APPS.BIS_OBJECTS_V

Source

View Text - Preformatted

SELECT obj.dependency_id, obj.OBJECT_NAME, obj.DATABASE_OBJECT_NAME, obj.DATABASE_OBJECT_LONGNAME, obj.OBJECT_TYPE_CODE, obj.APPLICATION_ID, appl.APPLICATION_NAME, obj.DEPENDENT_OBJECT_NAME, obj.REFRESH_MODE_CODE, obj.REFRESH_PROCESS_ID, obj.REFRESH_APPLICATION_ID, conc.user_concurrent_program_name REFRESH_PROCESS_LONGNAME, obj.LAST_REFRESH_TIME, obj.DESCRIPTION, obj.CREATED_BY, obj.CREATION_DATE, obj.LAST_UPDATED_BY, obj.LAST_UPDATE_LOGIN, obj.LAST_UPDATE_DATE from bis_objects obj, fnd_application_vl appl, fnd_concurrent_programs_vl conc where obj.application_id = appl.application_id(+) and obj.refresh_process_id = conc.concurrent_program_id(+) and obj.refresh_application_id = conc.application_id(+)

View Text - HTML Formatted

SELECT OBJ.DEPENDENCY_ID
, OBJ.OBJECT_NAME
, OBJ.DATABASE_OBJECT_NAME
, OBJ.DATABASE_OBJECT_LONGNAME
, OBJ.OBJECT_TYPE_CODE
, OBJ.APPLICATION_ID
, APPL.APPLICATION_NAME
, OBJ.DEPENDENT_OBJECT_NAME
, OBJ.REFRESH_MODE_CODE
, OBJ.REFRESH_PROCESS_ID
, OBJ.REFRESH_APPLICATION_ID
, CONC.USER_CONCURRENT_PROGRAM_NAME REFRESH_PROCESS_LONGNAME
, OBJ.LAST_REFRESH_TIME
, OBJ.DESCRIPTION
, OBJ.CREATED_BY
, OBJ.CREATION_DATE
, OBJ.LAST_UPDATED_BY
, OBJ.LAST_UPDATE_LOGIN
, OBJ.LAST_UPDATE_DATE
FROM BIS_OBJECTS OBJ
, FND_APPLICATION_VL APPL
, FND_CONCURRENT_PROGRAMS_VL CONC
WHERE OBJ.APPLICATION_ID = APPL.APPLICATION_ID(+)
AND OBJ.REFRESH_PROCESS_ID = CONC.CONCURRENT_PROGRAM_ID(+)
AND OBJ.REFRESH_APPLICATION_ID = CONC.APPLICATION_ID(+)