VIEW: OKL.OKL_TAX_TRX_DETAILS_T#

Source

View Text - Preformatted

select ID ID, TXS_ID TXS_ID, TAX_DETERMINATION_DATE TAX_DETERMINATION_DATE, TAX_RATE_ID TAX_RATE_ID, TAX_RATE_CODE TAX_RATE_CODE, TAXABLE_AMOUNT TAXABLE_AMOUNT, TAX_EXEMPTION_ID TAX_EXEMPTION_ID, TAX_RATE TAX_RATE, TAX_AMOUNT TAX_AMOUNT, BILLED_YN BILLED_YN, TAX_CALL_TYPE_CODE TAX_CALL_TYPE_CODE, PROGRAM_ID PROGRAM_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, 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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TAX_DETERMINE_DATE TAX_DETERMINE_DATE, TAXABLE_AMT TAXABLE_AMT, TAX_AMT TAX_AMT, TAX_DATE TAX_DATE, LINE_AMT LINE_AMT, INTERNAL_ORGANIZATION_ID INTERNAL_ORGANIZATION_ID, APPLICATION_ID APPLICATION_ID, ENTITY_CODE ENTITY_CODE, EVENT_CLASS_CODE EVENT_CLASS_CODE, EVENT_TYPE_CODE EVENT_TYPE_CODE, TRX_ID TRX_ID, TRX_LINE_ID TRX_LINE_ID, TRX_LEVEL_TYPE TRX_LEVEL_TYPE, TRX_LINE_NUMBER TRX_LINE_NUMBER, TAX_LINE_NUMBER TAX_LINE_NUMBER, TAX_REGIME_ID TAX_REGIME_ID, TAX_REGIME_CODE TAX_REGIME_CODE, TAX_ID TAX_ID, TAX TAX, TAX_STATUS_ID TAX_STATUS_ID, TAX_STATUS_CODE TAX_STATUS_CODE, TAX_APPORTIONMENT_LINE_NUMBER TAX_APPORTIONMENT_LINE_NUMBER, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, TRX_NUMBER TRX_NUMBER, TRX_DATE TRX_DATE, TAX_JURISDICTION_ID TAX_JURISDICTION_ID, TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE, TAX_TYPE_CODE TAX_TYPE_CODE, TAX_CURRENCY_CODE TAX_CURRENCY_CODE, TAXABLE_AMT_TAX_CURR TAXABLE_AMT_TAX_CURR, TRX_CURRENCY_CODE TRX_CURRENCY_CODE, MINIMUM_ACCOUNTABLE_UNIT MINIMUM_ACCOUNTABLE_UNIT, PRECISION PRECISION, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, UPGRADED_YN UPGRADED_YN, HDR_CODE HDR_CODE from "OKL"."OKL_TAX_TRX_DETAILS_T"

View Text - HTML Formatted

SELECT ID ID
, TXS_ID TXS_ID
, TAX_DETERMINATION_DATE TAX_DETERMINATION_DATE
, TAX_RATE_ID TAX_RATE_ID
, TAX_RATE_CODE TAX_RATE_CODE
, TAXABLE_AMOUNT TAXABLE_AMOUNT
, TAX_EXEMPTION_ID TAX_EXEMPTION_ID
, TAX_RATE TAX_RATE
, TAX_AMOUNT TAX_AMOUNT
, BILLED_YN BILLED_YN
, TAX_CALL_TYPE_CODE TAX_CALL_TYPE_CODE
, PROGRAM_ID PROGRAM_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, 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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TAX_DETERMINE_DATE TAX_DETERMINE_DATE
, TAXABLE_AMT TAXABLE_AMT
, TAX_AMT TAX_AMT
, TAX_DATE TAX_DATE
, LINE_AMT LINE_AMT
, INTERNAL_ORGANIZATION_ID INTERNAL_ORGANIZATION_ID
, APPLICATION_ID APPLICATION_ID
, ENTITY_CODE ENTITY_CODE
, EVENT_CLASS_CODE EVENT_CLASS_CODE
, EVENT_TYPE_CODE EVENT_TYPE_CODE
, TRX_ID TRX_ID
, TRX_LINE_ID TRX_LINE_ID
, TRX_LEVEL_TYPE TRX_LEVEL_TYPE
, TRX_LINE_NUMBER TRX_LINE_NUMBER
, TAX_LINE_NUMBER TAX_LINE_NUMBER
, TAX_REGIME_ID TAX_REGIME_ID
, TAX_REGIME_CODE TAX_REGIME_CODE
, TAX_ID TAX_ID
, TAX TAX
, TAX_STATUS_ID TAX_STATUS_ID
, TAX_STATUS_CODE TAX_STATUS_CODE
, TAX_APPORTIONMENT_LINE_NUMBER TAX_APPORTIONMENT_LINE_NUMBER
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, TRX_NUMBER TRX_NUMBER
, TRX_DATE TRX_DATE
, TAX_JURISDICTION_ID TAX_JURISDICTION_ID
, TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE
, TAX_TYPE_CODE TAX_TYPE_CODE
, TAX_CURRENCY_CODE TAX_CURRENCY_CODE
, TAXABLE_AMT_TAX_CURR TAXABLE_AMT_TAX_CURR
, TRX_CURRENCY_CODE TRX_CURRENCY_CODE
, MINIMUM_ACCOUNTABLE_UNIT MINIMUM_ACCOUNTABLE_UNIT
, PRECISION PRECISION
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, UPGRADED_YN UPGRADED_YN
, HDR_CODE HDR_CODE
FROM "OKL"."OKL_TAX_TRX_DETAILS_T"