106: MP.PROCESS_ENABLED_FLAG > 'Y'
107: ) MMTMMTA,
108: (select WRO.WIP_ENTITY_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.LAST_UPDATE_DATE,
109: WRO.WIP_ENTITY_ID ||'-'|| NVL(WRO.REPETITIVE_SCHEDULE_ID,'') JOB_ID
110: from WIP_REQUIREMENT_OPERATIONS WRO) WRO
111: WHERE
112: MMTMMTA.JOB_ID = WRO.JOB_ID (+)
113: GROUP BY
114: MMTMMTA.TRANSACTION_SOURCE_ID, MMTMMTA.REPETITIVE_SCHEDULE_ID, MMTMMTA.JOB_ID