View: PN_ADJUSTMENT_DETAILS_V

Product:	PN - Property Manager
Description:	Adjustment Details Form Views.
Implementation/DBA Data:	APPS.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