DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKL_TAX_SOURCES_V

Object Details
Object Name: OKL_TAX_SOURCES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_TAX_SOURCES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Primary Key
KHR_ID NUMBER

Contract ID
KLE_ID NUMBER

Contract line ID
ASSET_NUMBER VARCHAR2 (150)
No Longer Used
TRX_ID NUMBER
Yes Source Transaction ID
TRX_LINE_ID NUMBER
Yes Source Transaction Line ID
ENTITY_CODE VARCHAR2 (30) Yes Source Transaction Table
EVENT_CLASS_CODE VARCHAR2 (30) Yes Event Class Code used for tax calculation
TRX_LEVEL_TYPE VARCHAR2 (30) Yes Transaction Level Type - header/line
ADJUSTED_DOC_ENTITY_CODE VARCHAR2 (30)
Entity Code for the original transaction
ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
Event Class Code for the original transaction
ADJUSTED_DOC_TRX_ID NUMBER

Transaction ID for the original Transaction
ADJUSTED_DOC_TRX_LINE_ID NUMBER

Transaction Line ID for the original transaction
ADJUSTED_DOC_TRX_LEVEL_TYPE VARCHAR2 (30)
Transaction Level Type for the original transaction
ADJUSTED_DOC_NUMBER VARCHAR2 (150)
Document Number for the original transaction
ADJUSTED_DOC_DATE DATE

Document Date for the original transaction
TAX_CALL_TYPE_CODE VARCHAR2 (30) Yes Type of Tax Call
STY_ID NUMBER

Stream Type ID
TRX_BUSINESS_CATEGORY VARCHAR2 (240)
Transaction Business Category
TAX_LINE_STATUS_CODE VARCHAR2 (30) Yes Status of Tax Line
SEL_ID NUMBER

Stream Element ID
REPORTED_YN VARCHAR2 (1)
No Longer Used
PROGRAM_ID NUMBER (15)
Concurrent Manager Column
REQUEST_ID NUMBER

Concurrent Manager Column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager Column
PROGRAM_UPDATE_DATE DATE

Concurrent Manager Column
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive Flexfield Category Column
ATTRIBUTE1 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE2 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE3 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE4 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE5 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE6 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE7 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE8 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE9 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE10 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE11 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE12 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE13 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE14 VARCHAR2 (450)
Descriptive Flexfield Column
ATTRIBUTE15 VARCHAR2 (450)
Descriptive Flexfield Column
CREATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (9)
Column used for locking records during updates
LINE_NAME VARCHAR2 (150)
Asset Number or Service Line or Fee Line
APPLICATION_ID NUMBER
Yes Application Id
TAX_REPORTING_FLAG VARCHAR2 (1) Yes Tax Reporting Flag
DEFAULT_TAXATION_COUNTRY VARCHAR2 (2) Yes Default Taxation Country
PRODUCT_CATEGORY VARCHAR2 (240)
USER_DEFINED_FISC_CLASS VARCHAR2 (240)
User Defined Fiscal Classification
LINE_INTENDED_USE VARCHAR2 (240)
Line Intended Use
TAX_CLASSIFICATION_CODE VARCHAR2 (50)
Tax Classification Code
INVENTORY_ITEM_ID NUMBER

Inventory Item Id
BILL_TO_CUST_ACCT_ID NUMBER

Bill To Customer Account ID Id
ORG_ID NUMBER
Yes Org Id
LEGAL_ENTITY_ID NUMBER
Yes Legal Entity Id
LINE_AMT NUMBER

Line Amount
ASSESSABLE_VALUE NUMBER

Assessable Value
TOTAL_TAX NUMBER

Total Tax
PRODUCT_TYPE VARCHAR2 (240)
Product Type
PRODUCT_FISC_CLASSIFICATION VARCHAR2 (240)
Product Fiscal Classification
TRX_DATE DATE
Yes Transaction Date
PROVNL_TAX_DETERMINATION_DATE DATE

Provisional Tax Determination Date
TRY_ID NUMBER
Yes Transaction Type Id
SHIP_TO_LOCATION_ID NUMBER

Ship To Location Id
SHIP_TO_PARTY_SITE_ID NUMBER

Ship To Party Site Id
SHIP_TO_PARTY_ID NUMBER

Ship To Party Id
BILL_TO_PARTY_SITE_ID NUMBER

Bill To Party Site Id
BILL_TO_LOCATION_ID NUMBER

Bill To Location Id
BILL_TO_PARTY_ID NUMBER

Bill To Party Id
SHIP_TO_CUST_ACCT_SITE_USE_ID NUMBER

Ship To Customer Account Site Use Id
BILL_TO_CUST_ACCT_SITE_USE_ID NUMBER

Bill To Customer Account Site Use Id
TRX_CURRENCY_CODE VARCHAR2 (15) Yes Transaction Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
ALC_SERIALIZED_YN VARCHAR2 (1)
Asset Location Change tax call for serialized asset
ALC_SERIALIZED_TOTAL_TAX NUMBER

Total tax for all serial numbers for an asset
ALC_SERIALIZED_TOTAL_LINE_AMT NUMBER

Total taxable amount for all serial numbers for an asset
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

APPS.OKL_TAX_SOURCES_V references the following:

SchemaAPPS
SynonymOKL_TAX_SOURCES
APPS.OKL_TAX_SOURCES_V is referenced by following:

SchemaAPPS
Package BodyOKL_TXS_PVT - show dependent code