DBA Data[Home] [Help]

APPS.OPI_EDW_OPI_JOB_DETAIL_F_C dependencies on WIP_REPETITIVE_SCHEDULES

Line 62: WIP_ENTITIES EN, WIP_REPETITIVE_SCHEDULES RE, WIP_PERIOD_BALANCES WPB

58: RE.REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID,
59: EN.WIP_ENTITY_ID || '-' || RE.REPETITIVE_SCHEDULE_ID JOB_ID,
60: MAX(GREATEST(EN.LAST_UPDATE_DATE, RE.LAST_UPDATE_DATE, WPB.LAST_UPDATE_DATE)) LAST_UPDATE_DATE
61: FROM
62: WIP_ENTITIES EN, WIP_REPETITIVE_SCHEDULES RE, WIP_PERIOD_BALANCES WPB
63: WHERE
64: RE.STATUS_TYPE IN (4,5,7,12) AND
65: RE.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND RE.ORGANIZATION_ID = EN.ORGANIZATION_ID AND
66: RE.WIP_ENTITY_ID = WPB.WIP_ENTITY_ID AND RE.REPETITIVE_SCHEDULE_ID = WPB.REPETITIVE_SCHEDULE_ID