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

VIEW: APPS.OKL_CS_TAX_SUMMARY_UV

Object Details
Object Name: OKL_CS_TAX_SUMMARY_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CS_TAX_SUMMARY_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
TX_SOURCE_ID NUMBER
Yes Source Identifier for Tax.
TX_LINE_ID NUMBER
Yes Tax Line Identifier.
TRX_ID NUMBER
Yes Transaction Identifier.
TRX_LINE_ID NUMBER
Yes Transaction Line Identifier.
TAX_DATE DATE

Tax Date.
TAX_CODE VARCHAR2 (150)
Tax Code.
STREAM_TYPE VARCHAR2 (150) Yes Column used by the translation batch program
TAX_RATE NUMBER

Tax Rate.
TAXABLE_AMOUNT NUMBER

Taxable Amount.
TAX_AMOUNT NUMBER

Tax Amount.
TBC VARCHAR2 (240)
TBC Code.
Query Text

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


SELECT TX_SOURCE_ID
,      TX_LINE_ID
,      TRX_ID
,      TRX_LINE_ID
,      TAX_DATE
,      TAX_CODE
,      STREAM_TYPE
,      TAX_RATE
,      TAXABLE_AMOUNT
,      TAX_AMOUNT
,      TBC
FROM APPS.OKL_CS_TAX_SUMMARY_UV;

Dependencies

[top of page]

APPS.OKL_CS_TAX_SUMMARY_UV references the following:

SchemaAPPS
ViewOKL_STREAMS_V
ViewOKL_STRM_ELEMENTS_V
SynonymOKL_STRM_TYPE_TL
SynonymOKL_TAX_SOURCES
SynonymOKL_TAX_TRX_DETAILS

APPS.OKL_CS_TAX_SUMMARY_UV is not referenced by any database object