VIEW: APPS.ZPB_DC_OBJECTS_UTIL_V

Source

View Text - Preformatted

SELECT OBJECT_ID,AC_INSTANCE_ID as BUSINESS_PROCESS_ID, NAME as BP_NAME,INSTANCE_DESCRIPTION,TEMPLATE_ID,TEMPLATE_NAME,OBJECT_USER_ID USER_ID,USER_NAME FROM ZPB_DC_OBJECTS , FND_USER , ZPB_ANALYSIS_CYCLES,ZPB_ANALYSIS_CYCLE_INSTANCES WHERE ZPB_DC_OBJECTS.OBJECT_USER_ID = FND_USER.USER_ID AND ZPB_DC_OBJECTS.AC_INSTANCE_ID = ZPB_ANALYSIS_CYCLE_INSTANCES.INSTANCE_AC_ID AND ZPB_DC_OBJECTS.ANALYSIS_CYCLE_ID = ZPB_ANALYSIS_CYCLES.ANALYSIS_CYCLE_ID

View Text - HTML Formatted

SELECT OBJECT_ID
, AC_INSTANCE_ID AS BUSINESS_PROCESS_ID
, NAME AS BP_NAME
, INSTANCE_DESCRIPTION
, TEMPLATE_ID
, TEMPLATE_NAME
, OBJECT_USER_ID USER_ID
, USER_NAME
FROM ZPB_DC_OBJECTS
, FND_USER
, ZPB_ANALYSIS_CYCLES
, ZPB_ANALYSIS_CYCLE_INSTANCES
WHERE ZPB_DC_OBJECTS.OBJECT_USER_ID = FND_USER.USER_ID
AND ZPB_DC_OBJECTS.AC_INSTANCE_ID = ZPB_ANALYSIS_CYCLE_INSTANCES.INSTANCE_AC_ID
AND ZPB_DC_OBJECTS.ANALYSIS_CYCLE_ID = ZPB_ANALYSIS_CYCLES.ANALYSIS_CYCLE_ID