機械翻訳について

PON_OBJ_AGG_TO_PROG_OTBI_V

詳細

• スキーマ: FUSION

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

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

列

名前
PROGRAM_HEADER_ID OBJ_BS_CURRENT_SPEND_BY_PROG OBJ_BS_TARGET_SPEND_BY_PROG OBJ_BS_SAVINGS_GOAL_BY_PROG

問合せ

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