機械翻訳について

PON_NEG_AGG_TO_OBJ_OTBI_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: PON

• オブジェクト・タイプ: VIEW

列

名前
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

問合せ

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