APPS.OPI_EDW_OPI_JOB_DETAIL_F_C dependencies on WIP_PERIOD_BALANCES

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

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

Line 76: WIP_ENTITIES EN , WIP_FLOW_SCHEDULES FL, WIP_PERIOD_BALANCES WPB

72: TO_NUMBER(NULL) REPETITIVE_SCHEDULE_ID,
73: EN.WIP_ENTITY_ID || '-' JOB_ID,
74: MAX(GREATEST(EN.LAST_UPDATE_DATE, FL.LAST_UPDATE_DATE, WPB.LAST_UPDATE_DATE)) LAST_UPDATE_DATE
75: FROM
76: WIP_ENTITIES EN , WIP_FLOW_SCHEDULES FL, WIP_PERIOD_BALANCES WPB
77: WHERE
78: FL.STATUS = 2 AND
79: FL.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND FL.ORGANIZATION_ID = EN.ORGANIZATION_ID AND
80: FL.WIP_ENTITY_ID = WPB.WIP_ENTITY_ID