View: JAI_RCV_RGM_TAX_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.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