[Home] [Help]
View: BIS_CAUSE_EFFECT_V
| Product: | FND - Application Object Library |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT
CAUSE_SHORT_NAME
, EFFECT_SHORT_NAME
, MAX(CAUSE_SEQUENCE) CAUSE_SEQUENCE
, MAX(EFFECT_SEQUENCE) EFFECT_SEQUENCE
FROM (
SELECT
CAUSEINFO.SHORT_NAME CAUSE_SHORT_NAME
, EFFECTINFO.EFFECT_SHORT_NAME
, 0 CAUSE_SEQUENCE
, 0 EFFECT_SEQUENCE
FROM
BIS_INDICATORS CAUSEINFO
,
( SELECT
CE.CAUSE_INDICATOR
, I.SHORT_NAME EFFECT_SHORT_NAME
FROM
BSC_KPI_CAUSE_EFFECT_RELS CE
,
BIS_INDICATORS I
WHERE
I.DATASET_ID = CE.EFFECT_INDICATOR
AND (CE.EFFECT_LEVEL = 'DATASET' OR CE.CAUSE_LEVEL = 'DATASET')
) EFFECTINFO
WHERE
CAUSEINFO.DATASET_ID = EFFECTINFO.CAUSE_INDICATOR
MINUS
SELECT
CE.CAUSE_SHORT_NAME
, CE.EFFECT_SHORT_NAME
, 0 CAUSE_SEQUENCE
, 0 EFFECT_SEQUENCE
FROM
BIS_CUSTOM_CAUSE_EFFECT_RELS CE
WHERE
CAUSE_SEQUENCE = -1
AND EFFECT_SEQUENCE = -1
UNION
SELECT
CE.CAUSE_SHORT_NAME
, CE.EFFECT_SHORT_NAME
, CAUSE_SEQUENCE
, EFFECT_SEQUENCE
FROM
BIS_CUSTOM_CAUSE_EFFECT_RELS CE
WHERE
CAUSE_SEQUENCE <> -1
AND EFFECT_SEQUENCE <> -1
)GROUP BY CAUSE_SHORT_NAME
, EFFECT_SHORT_NAME