[Home] [Help]
View: JAI_RCV_RGM_TAX_V
View Text
SELECT A.SHIPMENT_HEADER_ID
, A.SHIPMENT_LINE_ID
, A.TAX_TYPE
, A.TAX_ID
, B.TAX_NAME
, NVL(SUM(A.INSTALLMENT_AMOUNT)
, 0) RECOVERABLE_AMOUNT
, NVL(SUM(A.CLAIMED_AMOUNT)
, 0) CLAIMED_AMOUNT
FROM JAI_RCV_RGM_CLAIMS A
, JAI_CMN_TAXES_ALL B
WHERE A.TAX_ID = B.TAX_ID GROUP BY A.SHIPMENT_HEADER_ID
, A.SHIPMENT_LINE_ID
, A.TAX_TYPE
, A.TAX_ID
, B.TAX_NAME
Columns
Name |
SHIPMENT_HEADER_ID |
SHIPMENT_LINE_ID |
TAX_TYPE |
TAX_ID |
TAX_NAME |
RECOVERABLE_AMOUNT |
CLAIMED_AMOUNT |