1. Tables and Views for Procurement
  2. PON_NEG_AGG_TO_PROG_OTBI_V

PON_NEG_AGG_TO_PROG_OTBI_V

Details

  • Schema: FUSION

  • Object owner: PON

  • Object type: VIEW

Columns

Name

PROGRAM_HEADER_ID

PLANNED_CURRENT_SPEND_BY_PROG

PLANNED_TARGET_SPEND_BY_PROG

PLANNED_SAVING_GOALS_BY_PROG

AWARD_AMOUNT_BY_PROG

Query

SQL_Statement

SELECT

NEG.PROGRAM_HEADER_ID,

SUM(NVL(NEG.PLANNED_CURRENT_SPEND, 0)) PLANNED_CURRENT_SPEND_BY_PROG,

SUM(NVL(NEG.PLANNED_TARGET_SPEND, 0)) PLANNED_TARGET_SPEND_BY_PROG,

SUM(NVL(NEG.PLANNED_SAVINGS, 0)) PLANNED_SAVING_GOALS_BY_PROG,

SUM(NVL(NEG.AWARD_AMOUNT, 0)) AWARD_AMOUNT_BY_PROG

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