[Home] [Help] [Dependency Information]
Object Name: | OKL_TAX_LINES_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_TAX_LINES_UV |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Identifier for the Tax Line - Primary Key | |
CONTRACT_ID | NUMBER | Foreign key to table OKL_K_HEADERS | ||
CONTRACT_LINE_ID | NUMBER | Foreign key to table OKL_K_LINES | ||
ASSET_NUMBER | VARCHAR2 | (150) | Asset Number | |
LINE_TYPE | VARCHAR2 | (0) | Tax Line Type | |
STREAM_TYPE | VARCHAR2 | (150) | Yes | Stream Type |
STREAM_ELEMENT_ID | NUMBER | Yes | Stream element Identifier | |
STREAM_AMOUNT | NUMBER | Yes | Stream Amount | |
DUE_DATE | DATE | Yes | Stream Due Date | |
ACTUAL_YN | VARCHAR2 | (1) | ||
TAX_RATE_CODE | VARCHAR2 | (0) | Tax rate code | |
TAXABLE_AMOUNT | NUMBER | Taxable amount | ||
TAX_RATE | VARCHAR2 | (0) | Tax rate | |
TAX_AMOUNT | NUMBER | Tax amount | ||
TRQ_ID | NUMBER | Yes | Transaction line Identifier | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
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 |
TRX_LINE_ID | NUMBER | Yes | ||
TAX_LINE_STATUS_CODE | VARCHAR2 | (30) | Yes | |
TRX_LEVEL_TYPE | VARCHAR2 | (30) | Yes | |
APPLICATION_ID | NUMBER | Yes | ||
ENTITY_CODE | VARCHAR2 | (30) | Yes | |
EVENT_CLASS_CODE | VARCHAR2 | (30) | Yes | |
TAX_CALL_TYPE_CODE | VARCHAR2 | (30) | Yes | |
STY_ID | NUMBER | Yes | Stream Type Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, CONTRACT_ID
, CONTRACT_LINE_ID
, ASSET_NUMBER
, LINE_TYPE
, STREAM_TYPE
, STREAM_ELEMENT_ID
, STREAM_AMOUNT
, DUE_DATE
, ACTUAL_YN
, TAX_RATE_CODE
, TAXABLE_AMOUNT
, TAX_RATE
, TAX_AMOUNT
, TRQ_ID
, CURRENCY_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TRX_LINE_ID
, TAX_LINE_STATUS_CODE
, TRX_LEVEL_TYPE
, APPLICATION_ID
, ENTITY_CODE
, EVENT_CLASS_CODE
, TAX_CALL_TYPE_CODE
, STY_ID
FROM APPS.OKL_TAX_LINES_UV;
APPS.OKL_TAX_LINES_UV is not referenced by any database object
|
|
|