[Home] [Help]
View: PN_ADJUSTMENT_DETAILS_V
View Text
SELECT PAD.TERM_HISTORY_ID TERM_HISTORY_ID
, PAD.GROUP_NUM GROUP_NUM
, MIN(PAD.ADJ_START_DATE) MIN_START_DATE
, MAX(PAD.ADJ_END_DATE) MAX_END_DATE
, SUM(PAD.ADJUSTMENT_AMOUNT) ADJUSTMENT_AMOUNT
FROM PN_ADJUSTMENT_DETAILS PAD GROUP BY PAD.GROUP_NUM
, PAD.TERM_HISTORY_ID
Columns
Name |
TERM_HISTORY_ID |
GROUP_NUM |
MIN_START_DATE |
MAX_END_DATE |
ADJUSTMENT_AMOUNT |