[Home] [Help]
View: JAI_RCV_RGM_INSTALLMENT_V
View Text
SELECT SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID
, INSTALLMENT_NO
, SCHEDULED_DATE
, NVL(SUM(A.INSTALLMENT_AMOUNT)
, 0) RECOVERABLE_AMOUNT
, NVL(SUM(A.CLAIMED_AMOUNT)
, 0) CLAIMED_AMOUNT
FROM JAI_RCV_RGM_CLAIMS A GROUP BY SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID
, INSTALLMENT_NO
, SCHEDULED_DATE
Columns
Name |
SHIPMENT_HEADER_ID |
SHIPMENT_LINE_ID |
INSTALLMENT_NO |
SCHEDULED_DATE |
RECOVERABLE_AMOUNT |
CLAIMED_AMOUNT |