VIEW: OKL.OKL_TAX_SOURCES#

Source

View Text - Preformatted

select ID ID, KHR_ID KHR_ID, KLE_ID KLE_ID, ASSET_NUMBER ASSET_NUMBER, TRX_ID TRX_ID, TRX_LINE_ID TRX_LINE_ID, ENTITY_CODE ENTITY_CODE, EVENT_CLASS_CODE EVENT_CLASS_CODE, TRX_LEVEL_TYPE TRX_LEVEL_TYPE, ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_ENTITY_CODE, ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_EVENT_CLASS_CODE, ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRX_ID, ADJUSTED_DOC_TRX_LINE_ID ADJUSTED_DOC_TRX_LINE_ID, ADJUSTED_DOC_TRX_LEVEL_TYPE ADJUSTED_DOC_TRX_LEVEL_TYPE, ADJUSTED_DOC_NUMBER ADJUSTED_DOC_NUMBER, ADJUSTED_DOC_DATE ADJUSTED_DOC_DATE, TAX_CALL_TYPE_CODE TAX_CALL_TYPE_CODE, STY_ID STY_ID, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY, TAX_LINE_STATUS_CODE TAX_LINE_STATUS_CODE, SEL_ID SEL_ID, REPORTED_YN REPORTED_YN, 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, LINE_NAME LINE_NAME, APPLICATION_ID APPLICATION_ID, TAX_REPORTING_FLAG TAX_REPORTING_FLAG, DEFAULT_TAXATION_COUNTRY DEFAULT_TAXATION_COUNTRY, PRODUCT_CATEGORY PRODUCT_CATEGORY, USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS, LINE_INTENDED_USE LINE_INTENDED_USE, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, BILL_TO_CUST_ACCT_ID BILL_TO_CUST_ACCT_ID, ORG_ID ORG_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, LINE_AMT LINE_AMT, ASSESSABLE_VALUE ASSESSABLE_VALUE, TOTAL_TAX TOTAL_TAX, PRODUCT_TYPE PRODUCT_TYPE, PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION, TRX_DATE TRX_DATE, PROVNL_TAX_DETERMINATION_DATE PROVNL_TAX_DETERMINATION_DATE, TRY_ID TRY_ID, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_SITE_ID, SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID, BILL_TO_PARTY_SITE_ID BILL_TO_PARTY_SITE_ID, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID, BILL_TO_PARTY_ID BILL_TO_PARTY_ID, SHIP_TO_CUST_ACCT_SITE_USE_ID SHIP_TO_CUST_ACCT_SITE_USE_ID, BILL_TO_CUST_ACCT_SITE_USE_ID BILL_TO_CUST_ACCT_SITE_USE_ID, TRX_CURRENCY_CODE TRX_CURRENCY_CODE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, ALC_SERIALIZED_YN ALC_SERIALIZED_YN, ALC_SERIALIZED_TOTAL_TAX ALC_SERIALIZED_TOTAL_TAX, ALC_SERIALIZED_TOTAL_LINE_AMT ALC_SERIALIZED_TOTAL_LINE_AMT from "OKL"."OKL_TAX_SOURCES"

View Text - HTML Formatted

SELECT ID ID
, KHR_ID KHR_ID
, KLE_ID KLE_ID
, ASSET_NUMBER ASSET_NUMBER
, TRX_ID TRX_ID
, TRX_LINE_ID TRX_LINE_ID
, ENTITY_CODE ENTITY_CODE
, EVENT_CLASS_CODE EVENT_CLASS_CODE
, TRX_LEVEL_TYPE TRX_LEVEL_TYPE
, ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_ENTITY_CODE
, ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_EVENT_CLASS_CODE
, ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRX_ID
, ADJUSTED_DOC_TRX_LINE_ID ADJUSTED_DOC_TRX_LINE_ID
, ADJUSTED_DOC_TRX_LEVEL_TYPE ADJUSTED_DOC_TRX_LEVEL_TYPE
, ADJUSTED_DOC_NUMBER ADJUSTED_DOC_NUMBER
, ADJUSTED_DOC_DATE ADJUSTED_DOC_DATE
, TAX_CALL_TYPE_CODE TAX_CALL_TYPE_CODE
, STY_ID STY_ID
, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY
, TAX_LINE_STATUS_CODE TAX_LINE_STATUS_CODE
, SEL_ID SEL_ID
, REPORTED_YN REPORTED_YN
, 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
, LINE_NAME LINE_NAME
, APPLICATION_ID APPLICATION_ID
, TAX_REPORTING_FLAG TAX_REPORTING_FLAG
, DEFAULT_TAXATION_COUNTRY DEFAULT_TAXATION_COUNTRY
, PRODUCT_CATEGORY PRODUCT_CATEGORY
, USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS
, LINE_INTENDED_USE LINE_INTENDED_USE
, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, BILL_TO_CUST_ACCT_ID BILL_TO_CUST_ACCT_ID
, ORG_ID ORG_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, LINE_AMT LINE_AMT
, ASSESSABLE_VALUE ASSESSABLE_VALUE
, TOTAL_TAX TOTAL_TAX
, PRODUCT_TYPE PRODUCT_TYPE
, PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION
, TRX_DATE TRX_DATE
, PROVNL_TAX_DETERMINATION_DATE PROVNL_TAX_DETERMINATION_DATE
, TRY_ID TRY_ID
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_SITE_ID
, SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID
, BILL_TO_PARTY_SITE_ID BILL_TO_PARTY_SITE_ID
, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, BILL_TO_PARTY_ID BILL_TO_PARTY_ID
, SHIP_TO_CUST_ACCT_SITE_USE_ID SHIP_TO_CUST_ACCT_SITE_USE_ID
, BILL_TO_CUST_ACCT_SITE_USE_ID BILL_TO_CUST_ACCT_SITE_USE_ID
, TRX_CURRENCY_CODE TRX_CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, ALC_SERIALIZED_YN ALC_SERIALIZED_YN
, ALC_SERIALIZED_TOTAL_TAX ALC_SERIALIZED_TOTAL_TAX
, ALC_SERIALIZED_TOTAL_LINE_AMT ALC_SERIALIZED_TOTAL_LINE_AMT
FROM "OKL"."OKL_TAX_SOURCES"