View: OE_UPGRADE_WF_MULGRP_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_UPGRADE_WF_MULGRP_V

View Text

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 )

Columns