PON_OBJ_AGG_TO_PROG_OTBI_V

Details

• Schema: FUSION

• Object owner: PON

• Object type: VIEW

Columns

Name
PROGRAM_HEADER_ID OBJ_BS_CURRENT_SPEND_BY_PROG OBJ_BS_TARGET_SPEND_BY_PROG OBJ_BS_SAVINGS_GOAL_BY_PROG

Query

SQL_Statement
SELECT PROGRAM_HEADER_ID, SUM(NVL(CURRENT_SPEND, 0)) OBJ_BS_CURRENT_SPEND_BY_PROG, SUM(NVL(TARGET_SPEND, 0)) OBJ_BS_TARGET_SPEND_BY_PROG, SUM(NVL(SAVINGS, 0)) OBJ_BS_SAVINGS_GOAL_BY_PROG FROM PON_PROGRAM_OBJECTIVES WHERE ROLL_UP_FLAG = 'Y' GROUP BY PROGRAM_HEADER_ID