VIEW: ZX.ZX_REP_MATRIX_EXT_T#

Source

View Text - Preformatted

select DETAIL_TAX_LINE_MAT_ID DETAIL_TAX_LINE_MAT_ID, DETAIL_TAX_LINE_ID DETAIL_TAX_LINE_ID, TAX1_STATUS_CODE TAX1_STATUS_CODE, TAX1_REGIME_CODE TAX1_REGIME_CODE, TAX1 TAX1, TAX1_RATE_CODE_ID TAX1_RATE_CODE_ID, TAX1_RATE_CODE TAX1_RATE_CODE, TAX1_RATE TAX1_RATE, TAX1_RATE_VAT_TRX_TYPE_CODE TAX1_RATE_VAT_TRX_TYPE_CODE, TAX1_RATE_VAT_TRX_TYPE_MNG TAX1_RATE_VAT_TRX_TYPE_MNG, TAX1_RATE_VAT_TRX_TYPE_DESC TAX1_RATE_VAT_TRX_TYPE_DESC, TAX1_RATE_CODE_REG_TYPE_CODE TAX1_RATE_CODE_REG_TYPE_CODE, TAX1_RATE_CODE_REG_TYPE_MNG TAX1_RATE_CODE_REG_TYPE_MNG, TAX1_RATE_CODE_TYPE_CODE TAX1_RATE_CODE_TYPE_CODE, TAX1_RATE_CODE_TYPE_MNG TAX1_RATE_CODE_TYPE_MNG, TAX1_RATE_CODE_NAME TAX1_RATE_CODE_NAME, TAX1_RATE_CODE_DESCRIPTION TAX1_RATE_CODE_DESCRIPTION, TAX1_RECOVERABLE_FLAG TAX1_RECOVERABLE_FLAG, TAX1_RECOVERY_RATE TAX1_RECOVERY_RATE, TAX2_STATUS_CODE TAX2_STATUS_CODE, TAX2_REGIME_CODE TAX2_REGIME_CODE, TAX2 TAX2, TAX2_RATE_CODE_ID TAX2_RATE_CODE_ID, TAX2_RATE_CODE TAX2_RATE_CODE, TAX2_RATE TAX2_RATE, TAX2_RATE_VAT_TRX_TYPE_CODE TAX2_RATE_VAT_TRX_TYPE_CODE, TAX2_RATE_VAT_TRX_TYPE_MNG TAX2_RATE_VAT_TRX_TYPE_MNG, TAX2_RATE_VAT_TRX_TYPE_DESC TAX2_RATE_VAT_TRX_TYPE_DESC, TAX2_RATE_CODE_REG_TYPE_CODE TAX2_RATE_CODE_REG_TYPE_CODE, TAX2_RATE_CODE_REG_TYPE_MNG TAX2_RATE_CODE_REG_TYPE_MNG, TAX2_RATE_CODE_TYPE_CODE TAX2_RATE_CODE_TYPE_CODE, TAX2_RATE_CODE_TYPE_MNG TAX2_RATE_CODE_TYPE_MNG, TAX2_RATE_CODE_NAME TAX2_RATE_CODE_NAME, TAX2_RATE_CODE_DESCRIPTION TAX2_RATE_CODE_DESCRIPTION, TAX2_RECOVERABLE_FLAG TAX2_RECOVERABLE_FLAG, TAX2_RECOVERY_RATE TAX2_RECOVERY_RATE, TAX3_STATUS_CODE TAX3_STATUS_CODE, TAX3_REGIME_CODE TAX3_REGIME_CODE, TAX3 TAX3, TAX3_RATE_CODE_ID TAX3_RATE_CODE_ID, TAX3_RATE_CODE TAX3_RATE_CODE, TAX3_RATE TAX3_RATE, TAX3_RATE_VAT_TRX_TYPE_CODE TAX3_RATE_VAT_TRX_TYPE_CODE, TAX3_RATE_VAT_TRX_TYPE_MNG TAX3_RATE_VAT_TRX_TYPE_MNG, TAX3_RATE_VAT_TRX_TYPE_DESC TAX3_RATE_VAT_TRX_TYPE_DESC, TAX3_RATE_CODE_REG_TYPE_CODE TAX3_RATE_CODE_REG_TYPE_CODE, TAX3_RATE_CODE_REG_TYPE_MNG TAX3_RATE_CODE_REG_TYPE_MNG, TAX3_RATE_CODE_TYPE_CODE TAX3_RATE_CODE_TYPE_CODE, TAX3_RATE_CODE_TYPE_MNG TAX3_RATE_CODE_TYPE_MNG, TAX3_RATE_CODE_NAME TAX3_RATE_CODE_NAME, TAX3_RATE_CODE_DESCRIPTION TAX3_RATE_CODE_DESCRIPTION, TAX3_RECOVERABLE_FLAG TAX3_RECOVERABLE_FLAG, TAX3_RECOVERY_RATE TAX3_RECOVERY_RATE, TAX4_STATUS_CODE TAX4_STATUS_CODE, TAX4_REGIME_CODE TAX4_REGIME_CODE, TAX4 TAX4, TAX4_RATE_CODE_ID TAX4_RATE_CODE_ID, TAX4_RATE_CODE TAX4_RATE_CODE, TAX4_RATE TAX4_RATE, TAX4_RATE_VAT_TRX_TYPE_CODE TAX4_RATE_VAT_TRX_TYPE_CODE, TAX4_RATE_VAT_TRX_TYPE_MNG TAX4_RATE_VAT_TRX_TYPE_MNG, TAX4_RATE_VAT_TRX_TYPE_DESC TAX4_RATE_VAT_TRX_TYPE_DESC, TAX4_RATE_CODE_REG_TYPE_CODE TAX4_RATE_CODE_REG_TYPE_CODE, TAX4_RATE_CODE_REG_TYPE_MNG TAX4_RATE_CODE_REG_TYPE_MNG, TAX4_RATE_CODE_TYPE_CODE TAX4_RATE_CODE_TYPE_CODE, TAX4_RATE_CODE_TYPE_MNG TAX4_RATE_CODE_TYPE_MNG, TAX4_RATE_CODE_NAME TAX4_RATE_CODE_NAME, TAX4_RATE_CODE_DESCRIPTION TAX4_RATE_CODE_DESCRIPTION, TAX4_RECOVERABLE_FLAG TAX4_RECOVERABLE_FLAG, TAX4_RECOVERY_RATE TAX4_RECOVERY_RATE, TAX1_AMT TAX1_AMT, TAX1_AMT_FUNCL_CUR TAX1_AMT_FUNCL_CUR, TAX1_LINE_NUMBER TAX1_LINE_NUMBER, TAXABLE1_AMT TAXABLE1_AMT, TAXABLE1_AMT_FUNCL_CURR TAXABLE1_AMT_FUNCL_CURR, TAXABLE2_AMT TAXABLE2_AMT, TAXABLE2_AMT_FUNCL_CURR TAXABLE2_AMT_FUNCL_CURR, TAXABLE3_AMT TAXABLE3_AMT, TAXABLE3_AMT_FUNCL_CURR TAXABLE3_AMT_FUNCL_CURR, TAXABLE4_AMT TAXABLE4_AMT, TAXABLE4_AMT_FUNCL_CURR TAXABLE4_AMT_FUNCL_CURR, TAX2_AMT TAX2_AMT, TAX2_AMT_FUNCL_CURR TAX2_AMT_FUNCL_CURR, TAX2_LINE_NUMBER TAX2_LINE_NUMBER, TAX3_AMT TAX3_AMT, TAX3_AMT_FUNCL_CUR TAX3_AMT_FUNCL_CUR, TAX3_LINE_NUMBER TAX3_LINE_NUMBER, TAX4_AMT TAX4_AMT, TAX4_AMT_FUNCL_CUR TAX4_AMT_FUNCL_CUR, TAX4_LINE_NUMBER TAX4_LINE_NUMBER, TAX1_DISC_AMT TAX1_DISC_AMT, TAX1_DISC_AMT_FUNCL_CURR TAX1_DISC_AMT_FUNCL_CURR, TAX2_DISC_AMT TAX2_DISC_AMT, TAX2_DISC_AMT_FUNCL_CURR TAX2_DISC_AMT_FUNCL_CURR, TAX3_DISC_AMT TAX3_DISC_AMT, TAX3_DISC_AMT_FUNCL_CURR TAX3_DISC_AMT_FUNCL_CURR, TAX4_DISC_AMT TAX4_DISC_AMT, TAX4_DISC_AMT_FUNCL_CURR TAX4_DISC_AMT_FUNCL_CURR, TAXABLE_DISC_AMT TAXABLE_DISC_AMT, TAXABLE_DISC_AMT_FUNCL_CURR TAXABLE_DISC_AMT_FUNCL_CURR, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID from "ZX"."ZX_REP_MATRIX_EXT_T"

View Text - HTML Formatted

SELECT DETAIL_TAX_LINE_MAT_ID DETAIL_TAX_LINE_MAT_ID
, DETAIL_TAX_LINE_ID DETAIL_TAX_LINE_ID
, TAX1_STATUS_CODE TAX1_STATUS_CODE
, TAX1_REGIME_CODE TAX1_REGIME_CODE
, TAX1 TAX1
, TAX1_RATE_CODE_ID TAX1_RATE_CODE_ID
, TAX1_RATE_CODE TAX1_RATE_CODE
, TAX1_RATE TAX1_RATE
, TAX1_RATE_VAT_TRX_TYPE_CODE TAX1_RATE_VAT_TRX_TYPE_CODE
, TAX1_RATE_VAT_TRX_TYPE_MNG TAX1_RATE_VAT_TRX_TYPE_MNG
, TAX1_RATE_VAT_TRX_TYPE_DESC TAX1_RATE_VAT_TRX_TYPE_DESC
, TAX1_RATE_CODE_REG_TYPE_CODE TAX1_RATE_CODE_REG_TYPE_CODE
, TAX1_RATE_CODE_REG_TYPE_MNG TAX1_RATE_CODE_REG_TYPE_MNG
, TAX1_RATE_CODE_TYPE_CODE TAX1_RATE_CODE_TYPE_CODE
, TAX1_RATE_CODE_TYPE_MNG TAX1_RATE_CODE_TYPE_MNG
, TAX1_RATE_CODE_NAME TAX1_RATE_CODE_NAME
, TAX1_RATE_CODE_DESCRIPTION TAX1_RATE_CODE_DESCRIPTION
, TAX1_RECOVERABLE_FLAG TAX1_RECOVERABLE_FLAG
, TAX1_RECOVERY_RATE TAX1_RECOVERY_RATE
, TAX2_STATUS_CODE TAX2_STATUS_CODE
, TAX2_REGIME_CODE TAX2_REGIME_CODE
, TAX2 TAX2
, TAX2_RATE_CODE_ID TAX2_RATE_CODE_ID
, TAX2_RATE_CODE TAX2_RATE_CODE
, TAX2_RATE TAX2_RATE
, TAX2_RATE_VAT_TRX_TYPE_CODE TAX2_RATE_VAT_TRX_TYPE_CODE
, TAX2_RATE_VAT_TRX_TYPE_MNG TAX2_RATE_VAT_TRX_TYPE_MNG
, TAX2_RATE_VAT_TRX_TYPE_DESC TAX2_RATE_VAT_TRX_TYPE_DESC
, TAX2_RATE_CODE_REG_TYPE_CODE TAX2_RATE_CODE_REG_TYPE_CODE
, TAX2_RATE_CODE_REG_TYPE_MNG TAX2_RATE_CODE_REG_TYPE_MNG
, TAX2_RATE_CODE_TYPE_CODE TAX2_RATE_CODE_TYPE_CODE
, TAX2_RATE_CODE_TYPE_MNG TAX2_RATE_CODE_TYPE_MNG
, TAX2_RATE_CODE_NAME TAX2_RATE_CODE_NAME
, TAX2_RATE_CODE_DESCRIPTION TAX2_RATE_CODE_DESCRIPTION
, TAX2_RECOVERABLE_FLAG TAX2_RECOVERABLE_FLAG
, TAX2_RECOVERY_RATE TAX2_RECOVERY_RATE
, TAX3_STATUS_CODE TAX3_STATUS_CODE
, TAX3_REGIME_CODE TAX3_REGIME_CODE
, TAX3 TAX3
, TAX3_RATE_CODE_ID TAX3_RATE_CODE_ID
, TAX3_RATE_CODE TAX3_RATE_CODE
, TAX3_RATE TAX3_RATE
, TAX3_RATE_VAT_TRX_TYPE_CODE TAX3_RATE_VAT_TRX_TYPE_CODE
, TAX3_RATE_VAT_TRX_TYPE_MNG TAX3_RATE_VAT_TRX_TYPE_MNG
, TAX3_RATE_VAT_TRX_TYPE_DESC TAX3_RATE_VAT_TRX_TYPE_DESC
, TAX3_RATE_CODE_REG_TYPE_CODE TAX3_RATE_CODE_REG_TYPE_CODE
, TAX3_RATE_CODE_REG_TYPE_MNG TAX3_RATE_CODE_REG_TYPE_MNG
, TAX3_RATE_CODE_TYPE_CODE TAX3_RATE_CODE_TYPE_CODE
, TAX3_RATE_CODE_TYPE_MNG TAX3_RATE_CODE_TYPE_MNG
, TAX3_RATE_CODE_NAME TAX3_RATE_CODE_NAME
, TAX3_RATE_CODE_DESCRIPTION TAX3_RATE_CODE_DESCRIPTION
, TAX3_RECOVERABLE_FLAG TAX3_RECOVERABLE_FLAG
, TAX3_RECOVERY_RATE TAX3_RECOVERY_RATE
, TAX4_STATUS_CODE TAX4_STATUS_CODE
, TAX4_REGIME_CODE TAX4_REGIME_CODE
, TAX4 TAX4
, TAX4_RATE_CODE_ID TAX4_RATE_CODE_ID
, TAX4_RATE_CODE TAX4_RATE_CODE
, TAX4_RATE TAX4_RATE
, TAX4_RATE_VAT_TRX_TYPE_CODE TAX4_RATE_VAT_TRX_TYPE_CODE
, TAX4_RATE_VAT_TRX_TYPE_MNG TAX4_RATE_VAT_TRX_TYPE_MNG
, TAX4_RATE_VAT_TRX_TYPE_DESC TAX4_RATE_VAT_TRX_TYPE_DESC
, TAX4_RATE_CODE_REG_TYPE_CODE TAX4_RATE_CODE_REG_TYPE_CODE
, TAX4_RATE_CODE_REG_TYPE_MNG TAX4_RATE_CODE_REG_TYPE_MNG
, TAX4_RATE_CODE_TYPE_CODE TAX4_RATE_CODE_TYPE_CODE
, TAX4_RATE_CODE_TYPE_MNG TAX4_RATE_CODE_TYPE_MNG
, TAX4_RATE_CODE_NAME TAX4_RATE_CODE_NAME
, TAX4_RATE_CODE_DESCRIPTION TAX4_RATE_CODE_DESCRIPTION
, TAX4_RECOVERABLE_FLAG TAX4_RECOVERABLE_FLAG
, TAX4_RECOVERY_RATE TAX4_RECOVERY_RATE
, TAX1_AMT TAX1_AMT
, TAX1_AMT_FUNCL_CUR TAX1_AMT_FUNCL_CUR
, TAX1_LINE_NUMBER TAX1_LINE_NUMBER
, TAXABLE1_AMT TAXABLE1_AMT
, TAXABLE1_AMT_FUNCL_CURR TAXABLE1_AMT_FUNCL_CURR
, TAXABLE2_AMT TAXABLE2_AMT
, TAXABLE2_AMT_FUNCL_CURR TAXABLE2_AMT_FUNCL_CURR
, TAXABLE3_AMT TAXABLE3_AMT
, TAXABLE3_AMT_FUNCL_CURR TAXABLE3_AMT_FUNCL_CURR
, TAXABLE4_AMT TAXABLE4_AMT
, TAXABLE4_AMT_FUNCL_CURR TAXABLE4_AMT_FUNCL_CURR
, TAX2_AMT TAX2_AMT
, TAX2_AMT_FUNCL_CURR TAX2_AMT_FUNCL_CURR
, TAX2_LINE_NUMBER TAX2_LINE_NUMBER
, TAX3_AMT TAX3_AMT
, TAX3_AMT_FUNCL_CUR TAX3_AMT_FUNCL_CUR
, TAX3_LINE_NUMBER TAX3_LINE_NUMBER
, TAX4_AMT TAX4_AMT
, TAX4_AMT_FUNCL_CUR TAX4_AMT_FUNCL_CUR
, TAX4_LINE_NUMBER TAX4_LINE_NUMBER
, TAX1_DISC_AMT TAX1_DISC_AMT
, TAX1_DISC_AMT_FUNCL_CURR TAX1_DISC_AMT_FUNCL_CURR
, TAX2_DISC_AMT TAX2_DISC_AMT
, TAX2_DISC_AMT_FUNCL_CURR TAX2_DISC_AMT_FUNCL_CURR
, TAX3_DISC_AMT TAX3_DISC_AMT
, TAX3_DISC_AMT_FUNCL_CURR TAX3_DISC_AMT_FUNCL_CURR
, TAX4_DISC_AMT TAX4_DISC_AMT
, TAX4_DISC_AMT_FUNCL_CURR TAX4_DISC_AMT_FUNCL_CURR
, TAXABLE_DISC_AMT TAXABLE_DISC_AMT
, TAXABLE_DISC_AMT_FUNCL_CURR TAXABLE_DISC_AMT_FUNCL_CURR
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
FROM "ZX"."ZX_REP_MATRIX_EXT_T"