eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKL_CS_TERMQTE_TAX_SUM_UV

Object Details

Object Name:	OKL_CS_TERMQTE_TAX_SUM_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_CS_TERMQTE_TAX_SUM_UV
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BILL_TO_CUSTOMER	VARCHAR2	(272)		Bill To Customer Name and Number
LINE_TYPE	VARCHAR2	(80)		Line Type
LINE_NAME	VARCHAR2	(150)		Line Name
STREAM_TYPE	VARCHAR2	(80)		Stream Type
ASSET_LOCATION	VARCHAR2	(4000)		Asset Location
TAX_DATE	DATE		Yes	Tax Determination Date
TAXABLE_AMOUNT	NUMBER			Taxable Amount
TOTAL_TAX	NUMBER			Total Tax Amount
TRX_BUSINESS_CATEGORY	VARCHAR2	(1996)		Transaction Business Category
PRODUCT_CATEGORY	VARCHAR2	(1996)		Product Category
USER_DEFINED_FISC_CLASS	VARCHAR2	(240)		User Defined Fiscal Classifcation
LINE_INTENDED_USE	VARCHAR2	(240)		Line Intended Use
KLE_ID	NUMBER			Contract Top line Identifier
KHR_ID	NUMBER			Contract Identifier
TRX_ID	NUMBER		Yes	Transaction Identifier
TRX_LINE_ID	NUMBER		Yes	Transaction Line Identifier
ENTITY_CODE	VARCHAR2	(30)	Yes	Entity Code
EVENT_CLASS_CODE	VARCHAR2	(30)	Yes	Event Class Code
APPLICATION_ID	NUMBER		Yes	Application Identifier
TRX_LEVEL_TYPE	VARCHAR2	(30)	Yes	Transaction Level Type
TAX_CALL_TYPE_CODE	VARCHAR2	(30)	Yes	Tax Call Type Code
TAX_LINE_STATUS_CODE	VARCHAR2	(30)	Yes	Tax Line Status Code
TRY_ID	NUMBER		Yes	Transaction Type Identifier
TRX_CURRENCY_CODE	VARCHAR2	(15)	Yes	Transaction Currency Code
LEGAL_ENTITY_ID	NUMBER		Yes	Legal Entity Id
ORG_ID	NUMBER		Yes	Org Identifier
PC_CODE	VARCHAR2	(240)
UFC_CODE	VARCHAR2	(240)
IU_CODE	VARCHAR2	(240)
TBC_CODE	VARCHAR2	(240)
DEFAULT_TAXATION_COUNTRY	VARCHAR2	(2)	Yes

Query Text

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


SELECT BILL_TO_CUSTOMER
,      LINE_TYPE
,      LINE_NAME
,      STREAM_TYPE
,      ASSET_LOCATION
,      TAX_DATE
,      TAXABLE_AMOUNT
,      TOTAL_TAX
,      TRX_BUSINESS_CATEGORY
,      PRODUCT_CATEGORY
,      USER_DEFINED_FISC_CLASS
,      LINE_INTENDED_USE
,      KLE_ID
,      KHR_ID
,      TRX_ID
,      TRX_LINE_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      APPLICATION_ID
,      TRX_LEVEL_TYPE
,      TAX_CALL_TYPE_CODE
,      TAX_LINE_STATUS_CODE
,      TRY_ID
,      TRX_CURRENCY_CODE
,      LEGAL_ENTITY_ID
,      ORG_ID
,      PC_CODE
,      UFC_CODE
,      IU_CODE
,      TBC_CODE
,      DEFAULT_TAXATION_COUNTRY
FROM APPS.OKL_CS_TERMQTE_TAX_SUM_UV;

Dependencies

[top of page]

APPS.OKL_CS_TERMQTE_TAX_SUM_UV references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; HZ_CUST_ACCOUNTS; OKC_K_LINES_B; OKC_LINE_STYLES_B; OKL_LLA_UTIL_PVT - show dependent code; OKL_STRM_TYPE_B; OKL_TAX_SOURCES; ZX_FC_CODES_DENORM_B; ZX_FC_INTENDED_USE_V; ZX_FC_PRODUCT_CATEGORIES_V; ZX_FC_USER_DEFINED_V

APPS.OKL_CS_TERMQTE_TAX_SUM_UV is not referenced by any database object