View: JAI_RGM_STL_BALANCES_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_RGM_STL_BALANCES_V

View Text

SELECT JRS.SETTLEMENT_ID
, JRS.REGIME_ID
, JRSL.TAX_TYPE
, SUM(JRSL.DEBIT_BALANCE) DEBIT
, SUM(JRSL.CREDIT_BALANCE) CREDIT
, SUM(JRSL.CREDIT_UTILIZED) CREDIT_UTILIZED
FROM JAI_RGM_STL_BALANCES JRSL
, JAI_RGM_SETTLEMENTS JRS
, JAI_RGM_REGISTRATIONS JRR
WHERE JRSL.SETTLEMENT_ID = JRS.SETTLEMENT_ID
AND JRS.REGIME_ID = JRR.REGIME_ID
AND JRR.REGISTRATION_TYPE = 'TAX_TYPES'
AND JRSL.TAX_TYPE = JRR.ATTRIBUTE_CODE GROUP BY JRS.SETTLEMENT_ID
, JRS.REGIME_ID
, JRSL.TAX_TYPE
, JRR.ATTRIBUTE_SEQUENCE ORDER BY JRR.ATTRIBUTE_SEQUENCE

Columns