VIEW: APPS.OE_UPGRADE_WF_MULGRP_V

Source

View Text - Preformatted

SELECT distinct a.cycle_action_id, a.action_id from so_action_pre_reqs a, so_cycle_actions b WHERE (a.cycle_action_id, a.group_number) in (select cycle_action_id, group_number from so_action_pre_reqs group by cycle_action_id, group_number having count(*) > 1 )

View Text - HTML Formatted

SELECT DISTINCT A.CYCLE_ACTION_ID
, A.ACTION_ID
FROM SO_ACTION_PRE_REQS A
, SO_CYCLE_ACTIONS B
WHERE (A.CYCLE_ACTION_ID
, A.GROUP_NUMBER) IN (SELECT CYCLE_ACTION_ID
, GROUP_NUMBER
FROM SO_ACTION_PRE_REQS GROUP BY CYCLE_ACTION_ID
, GROUP_NUMBER HAVING COUNT(*) > 1 )