APPS.OPI_EDW_OPI_JOB_DETAIL_F_C dependencies on WIP_FLOW_SCHEDULES

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