VIEW: APPS.OKL_TAX_SOURCES_V

Source

View Text - Preformatted

SELECT TXS.ID, TXS.KHR_ID, TXS.KLE_ID, TXS.ASSET_NUMBER, TXS.TRX_ID, TXS.TRX_LINE_ID, TXS.ENTITY_CODE, TXS.EVENT_CLASS_CODE, TXS.TRX_LEVEL_TYPE, TXS.ADJUSTED_DOC_ENTITY_CODE, TXS.ADJUSTED_DOC_EVENT_CLASS_CODE, TXS.ADJUSTED_DOC_TRX_ID, TXS.ADJUSTED_DOC_TRX_LINE_ID, TXS.ADJUSTED_DOC_TRX_LEVEL_TYPE, TXS.ADJUSTED_DOC_NUMBER, TXS.ADJUSTED_DOC_DATE, TXS.TAX_CALL_TYPE_CODE, TXS.STY_ID, TXS.TRX_BUSINESS_CATEGORY, TXS.TAX_LINE_STATUS_CODE, TXS.SEL_ID, TXS.REPORTED_YN, TXS.PROGRAM_ID, TXS.REQUEST_ID, TXS.PROGRAM_APPLICATION_ID, TXS.PROGRAM_UPDATE_DATE, TXS.ATTRIBUTE_CATEGORY, TXS.ATTRIBUTE1, TXS.ATTRIBUTE2, TXS.ATTRIBUTE3, TXS.ATTRIBUTE4, TXS.ATTRIBUTE5, TXS.ATTRIBUTE6, TXS.ATTRIBUTE7, TXS.ATTRIBUTE8, TXS.ATTRIBUTE9, TXS.ATTRIBUTE10, TXS.ATTRIBUTE11, TXS.ATTRIBUTE12, TXS.ATTRIBUTE13, TXS.ATTRIBUTE14, TXS.ATTRIBUTE15, TXS.CREATED_BY, TXS.CREATION_DATE, TXS.LAST_UPDATED_BY, TXS.LAST_UPDATE_DATE, TXS.LAST_UPDATE_LOGIN, TXS.OBJECT_VERSION_NUMBER, TXS.LINE_NAME, TXS.APPLICATION_ID, TXS.TAX_REPORTING_FLAG, TXS.DEFAULT_TAXATION_COUNTRY, TXS.PRODUCT_CATEGORY, TXS.USER_DEFINED_FISC_CLASS, TXS.LINE_INTENDED_USE, TXS.TAX_CLASSIFICATION_CODE, TXS.INVENTORY_ITEM_ID, TXS.BILL_TO_CUST_ACCT_ID, TXS.ORG_ID, TXS.LEGAL_ENTITY_ID, TXS.LINE_AMT, TXS.ASSESSABLE_VALUE, TXS.TOTAL_TAX, TXS.PRODUCT_TYPE, TXS.PRODUCT_FISC_CLASSIFICATION, TXS.TRX_DATE, TXS.PROVNL_TAX_DETERMINATION_DATE, TXS.TRY_ID, TXS.SHIP_TO_LOCATION_ID, TXS.SHIP_TO_PARTY_SITE_ID, TXS.SHIP_TO_PARTY_ID, TXS.BILL_TO_PARTY_SITE_ID, TXS.BILL_TO_LOCATION_ID, TXS.BILL_TO_PARTY_ID, TXS.SHIP_TO_CUST_ACCT_SITE_USE_ID, TXS.BILL_TO_CUST_ACCT_SITE_USE_ID, TXS.TRX_CURRENCY_CODE, TXS.CURRENCY_CONVERSION_TYPE, TXS.CURRENCY_CONVERSION_RATE, TXS.CURRENCY_CONVERSION_DATE, TXS.ALC_SERIALIZED_YN, TXS.ALC_SERIALIZED_TOTAL_TAX, TXS.ALC_SERIALIZED_TOTAL_LINE_AMT FROM OKL_TAX_SOURCES TXS

View Text - HTML Formatted

SELECT TXS.ID
, TXS.KHR_ID
, TXS.KLE_ID
, TXS.ASSET_NUMBER
, TXS.TRX_ID
, TXS.TRX_LINE_ID
, TXS.ENTITY_CODE
, TXS.EVENT_CLASS_CODE
, TXS.TRX_LEVEL_TYPE
, TXS.ADJUSTED_DOC_ENTITY_CODE
, TXS.ADJUSTED_DOC_EVENT_CLASS_CODE
, TXS.ADJUSTED_DOC_TRX_ID
, TXS.ADJUSTED_DOC_TRX_LINE_ID
, TXS.ADJUSTED_DOC_TRX_LEVEL_TYPE
, TXS.ADJUSTED_DOC_NUMBER
, TXS.ADJUSTED_DOC_DATE
, TXS.TAX_CALL_TYPE_CODE
, TXS.STY_ID
, TXS.TRX_BUSINESS_CATEGORY
, TXS.TAX_LINE_STATUS_CODE
, TXS.SEL_ID
, TXS.REPORTED_YN
, TXS.PROGRAM_ID
, TXS.REQUEST_ID
, TXS.PROGRAM_APPLICATION_ID
, TXS.PROGRAM_UPDATE_DATE
, TXS.ATTRIBUTE_CATEGORY
, TXS.ATTRIBUTE1
, TXS.ATTRIBUTE2
, TXS.ATTRIBUTE3
, TXS.ATTRIBUTE4
, TXS.ATTRIBUTE5
, TXS.ATTRIBUTE6
, TXS.ATTRIBUTE7
, TXS.ATTRIBUTE8
, TXS.ATTRIBUTE9
, TXS.ATTRIBUTE10
, TXS.ATTRIBUTE11
, TXS.ATTRIBUTE12
, TXS.ATTRIBUTE13
, TXS.ATTRIBUTE14
, TXS.ATTRIBUTE15
, TXS.CREATED_BY
, TXS.CREATION_DATE
, TXS.LAST_UPDATED_BY
, TXS.LAST_UPDATE_DATE
, TXS.LAST_UPDATE_LOGIN
, TXS.OBJECT_VERSION_NUMBER
, TXS.LINE_NAME
, TXS.APPLICATION_ID
, TXS.TAX_REPORTING_FLAG
, TXS.DEFAULT_TAXATION_COUNTRY
, TXS.PRODUCT_CATEGORY
, TXS.USER_DEFINED_FISC_CLASS
, TXS.LINE_INTENDED_USE
, TXS.TAX_CLASSIFICATION_CODE
, TXS.INVENTORY_ITEM_ID
, TXS.BILL_TO_CUST_ACCT_ID
, TXS.ORG_ID
, TXS.LEGAL_ENTITY_ID
, TXS.LINE_AMT
, TXS.ASSESSABLE_VALUE
, TXS.TOTAL_TAX
, TXS.PRODUCT_TYPE
, TXS.PRODUCT_FISC_CLASSIFICATION
, TXS.TRX_DATE
, TXS.PROVNL_TAX_DETERMINATION_DATE
, TXS.TRY_ID
, TXS.SHIP_TO_LOCATION_ID
, TXS.SHIP_TO_PARTY_SITE_ID
, TXS.SHIP_TO_PARTY_ID
, TXS.BILL_TO_PARTY_SITE_ID
, TXS.BILL_TO_LOCATION_ID
, TXS.BILL_TO_PARTY_ID
, TXS.SHIP_TO_CUST_ACCT_SITE_USE_ID
, TXS.BILL_TO_CUST_ACCT_SITE_USE_ID
, TXS.TRX_CURRENCY_CODE
, TXS.CURRENCY_CONVERSION_TYPE
, TXS.CURRENCY_CONVERSION_RATE
, TXS.CURRENCY_CONVERSION_DATE
, TXS.ALC_SERIALIZED_YN
, TXS.ALC_SERIALIZED_TOTAL_TAX
, TXS.ALC_SERIALIZED_TOTAL_LINE_AMT
FROM OKL_TAX_SOURCES TXS