CN_SRP_GOALS_V

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name

SRP_FORM_METRIC_ID SRP_PER_GOAL_ID PERIOD_ID SRP_INTERVAL_GOAL_ID SRP_COMP_PLAN_ID FORMULA_ID GOAL_ID GOAL_TARGET ALT_TARGET_1 ALT_TARGET_2 ALT_TARGET_3 ALT_TARGET_4 ALT_TARGET_5 INTERVAL_NUMBER INTERVAL_TARGET ALT_TARGET_1_INT ALT_TARGET_2_INT ALT_TARGET_3_INT ALT_TARGET_4_INT ALT_TARGET_5_INT TARGET_ITD TARGET_PER ALT_TARGET_1_ITD ALT_TARGET_1_PER ALT_TARGET_2_ITD ALT_TARGET_2_PER ALT_TARGET_3_ITD ALT_TARGET_3_PER ALT_TARGET_4_ITD ALT_TARGET_4_PER ALT_TARGET_5_ITD ALT_TARGET_5_PER INTERVAL_GOAL_ID

Query

SQL_Statement

SELECT SG.SRP_FORM_METRIC_ID, SPG.SRP_PER_GOAL_ID, SPG.PERIOD_ID, SPG.SRP_INTERVAL_GOAL_ID, SPG.SRP_COMP_PLAN_ID, SPG.FORMULA_ID, SPG.GOAL_ID, SG.TARGET GOAL_TARGET, SG.ALT_TARGET_1, SG.ALT_TARGET_2, SG.ALT_TARGET_3, SG.ALT_TARGET_4, SG.ALT_TARGET_5, SIG.INTERVAL_NUMBER INTERVAL_NUMBER, SIG.TARGET_INT INTERVAL_TARGET, SIG.ALT_TARGET_1_INT, SIG.ALT_TARGET_2_INT, SIG.ALT_TARGET_3_INT, SIG.ALT_TARGET_4_INT, SIG.ALT_TARGET_5_INT, SPG.TARGET_ITD, SPG.TARGET_PER, SPG.ALT_TARGET_1_ITD, SPG.ALT_TARGET_1_PER, SPG.ALT_TARGET_2_ITD, SPG.ALT_TARGET_2_PER, SPG.ALT_TARGET_3_ITD, SPG.ALT_TARGET_3_PER, SPG.ALT_TARGET_4_ITD, SPG.ALT_TARGET_4_PER, SPG.ALT_TARGET_5_ITD, SPG.ALT_TARGET_5_PER, SPG.INTERVAL_GOAL_ID FROM CN_SRP_PER_GOALS_ALL SPG, CN_SRP_INTERVAL_GOALS_ALL SIG, CN_SRP_GOALS_ALL SG WHERE SG.SRP_GOAL_ID = SIG.SRP_GOAL_ID AND SIG.SRP_INTERVAL_GOAL_ID = SPG.SRP_INTERVAL_GOAL_ID