APPS.OPI_EDW_OPI_JOB_DETAIL_F_C dependencies on WIP_DISCRETE_JOBS

Line 48: FROM WIP_ENTITIES EN , WIP_DISCRETE_JOBS DI, WIP_PERIOD_BALANCES WPB

44: EN.WIP_ENTITY_ID WIP_ENTITY_ID,
45: TO_NUMBER(NULL) REPETITIVE_SCHEDULE_ID,
46: EN.WIP_ENTITY_ID || '-' JOB_ID,
47: MAX(GREATEST(EN.LAST_UPDATE_DATE, DI.LAST_UPDATE_DATE, WPB.LAST_UPDATE_DATE)) LAST_UPDATE_DATE
48: FROM WIP_ENTITIES EN , WIP_DISCRETE_JOBS DI, WIP_PERIOD_BALANCES WPB
49: WHERE
50: DI.STATUS_TYPE IN (4,5,7,12) AND
51: DI.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND DI.ORGANIZATION_ID = EN.ORGANIZATION_ID AND
52: DI.WIP_ENTITY_ID = WPB.WIP_ENTITY_ID