PON_NEG_AGG_TO_OBJ_OTBI_V
Details
-
Schema: FUSION
-
Object owner: PON
-
Object type: VIEW
Columns
Name |
---|
PROGRAM_HEADER_ID OBJECTIVE_HEADER_ID PLANNED_CURRENT_SPEND_BY_OBJ PLANNED_TARGET_SPEND_BY_OBJ PLANNED_SAVING_GOALS_BY_OBJ AWARD_AMOUNT_BY_OBJ |
Query
SQL_Statement |
---|
SELECT NEG.PROGRAM_HEADER_ID, NEG.OBJECTIVE_HEADER_ID, SUM(NVL(NEG.PLANNED_CURRENT_SPEND, 0)) PLANNED_CURRENT_SPEND_BY_OBJ, SUM(NVL(NEG.PLANNED_TARGET_SPEND, 0)) PLANNED_TARGET_SPEND_BY_OBJ, SUM(NVL(NEG.PLANNED_SAVINGS, 0)) PLANNED_SAVING_GOALS_BY_OBJ, SUM(NVL(NEG.AWARD_AMOUNT, 0)) AWARD_AMOUNT_BY_OBJ FROM PON_OBJECTIVE_NEGOTIATIONS NEG, PON_PROGRAM_OBJECTIVES OBJ WHERE NEG.OBJECTIVE_HEADER_ID = OBJ.OBJECTIVE_HEADER_ID AND OBJ.ROLL_UP_FLAG = 'Y' GROUP BY NEG.PROGRAM_HEADER_ID, NEG.OBJECTIVE_HEADER_ID |