[Home] [Help] [Dependency Information]
Object Name: | OKL_TXL_QTE_LINES_ALL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_TXL_QTE_LINES_ALL_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
All org view for Termination, restructure or repurchase quote lines
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Auto-generated by Headstart Utilities | |
ID | NUMBER | Yes | Primary key column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Column used by the translation batch program |
QLT_CODE | VARCHAR2 | (30) | The quote line type code. The FND lookup type is OKL_QUOTE_LINE_TYPE | |
KLE_ID | NUMBER | Foreign key to table OKL_K_LINES | ||
STY_ID | NUMBER | Foreign key to table OKL_STRM_TYPE_B | ||
QTE_ID | NUMBER | Yes | Foreign key to table OKL_TRX_QUOTES_B | |
LINE_NUMBER | NUMBER | Yes | Line number | |
DESCRIPTION | VARCHAR2 | (1995) | A general description of something | |
AMOUNT | NUMBER | (14) | Yes | Amount |
MODIFIED_YN | VARCHAR2 | (3) | Has this amount been modified/updated by a user after the amount was calculated | |
TAXED_YN | VARCHAR2 | (3) | Has tax been calculated on this quote element | |
DEFAULTED_YN | VARCHAR2 | (3) | The amount could not be calculated, so it is defaulted with a zero amount | |
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 | |
ORG_ID | NUMBER | (15) | Operating unit identifier | |
REQUEST_ID | NUMBER | (15) | Concurrent Manager column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Manager column | |
PROGRAM_ID | NUMBER | (15) | Concurrent Manager column | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Manager 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) | Standard who column | |
START_DATE | DATE | Start date | ||
PERIOD | VARCHAR2 | (30) | The type of period for restructure quote lines | |
NUMBER_OF_PERIODS | NUMBER | (4) | The number of periods covered | |
LOCK_LEVEL_STEP | VARCHAR2 | (10) | Indicator to determine whether the restructure quote line is locked | |
ADVANCE_OR_ARREARS | VARCHAR2 | (10) | Indicates if the restructure quote line is for advace or arrears | |
YIELD_NAME | VARCHAR2 | (150) | The yield name | |
YIELD_VALUE | NUMBER | (18) | The yield value | |
IMPLICIT_INTEREST_RATE | NUMBER | (18) | The implicit interest rate | |
ASSET_VALUE | NUMBER | (14) | The asset value is the calculated NBV, NIV or Principal value based on the contract type. This value is prorated against the actual units included in the quote line | |
RESIDUAL_VALUE | NUMBER | (14) | The residual value is the amount taken from the residual value on the asset line for which the quote line is based. This value is prorated against the actual units included in the quote line | |
UNBILLED_RECEIVABLES | NUMBER | (14) | The unbilled receivables amount is the calculated value on the asset line for which the quote line is based. This value is prorated against the actual units included in the quote line | |
ASSET_QUANTITY | NUMBER | (14) | Total number of units associated with the asset line | |
QUOTE_QUANTITY | NUMBER | (14) | Total number of units associated with the quoteline | |
SPLIT_KLE_ID | NUMBER | The identifier for the split contract line | ||
SPLIT_KLE_NAME | VARCHAR2 | (150) | The new asset number after an asset split | |
CURRENCY_CODE | VARCHAR2 | (15) | Indicates the currency in which the amounts are stored | |
CURRENCY_CONVERSION_CODE | VARCHAR2 | (15) | Indicates the target currency of the conversion information | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | The conversion type (spot, user or corporate) | |
CURRENCY_CONVERSION_RATE | NUMBER | The conversion rate to convert the amounts from the CURRENCY_CODE to the CURRENCY_CONVERSION_CODE | ||
CURRENCY_CONVERSION_DATE | DATE | The conversion date the conversion rate was determined | ||
DUE_DATE | DATE | Indicates the due date of the quote amount, mainly used for estimated billing adjustment quote line | ||
TRY_ID | NUMBER | Foreign key to table OKL_TRX_TYPES_B |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, QLT_CODE
, KLE_ID
, STY_ID
, QTE_ID
, LINE_NUMBER
, DESCRIPTION
, AMOUNT
, MODIFIED_YN
, TAXED_YN
, DEFAULTED_YN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, START_DATE
, PERIOD
, NUMBER_OF_PERIODS
, LOCK_LEVEL_STEP
, ADVANCE_OR_ARREARS
, YIELD_NAME
, YIELD_VALUE
, IMPLICIT_INTEREST_RATE
, ASSET_VALUE
, RESIDUAL_VALUE
, UNBILLED_RECEIVABLES
, ASSET_QUANTITY
, QUOTE_QUANTITY
, SPLIT_KLE_ID
, SPLIT_KLE_NAME
, CURRENCY_CODE
, CURRENCY_CONVERSION_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, DUE_DATE
, TRY_ID
FROM APPS.OKL_TXL_QTE_LINES_ALL_V;
|
|
|