[Home] [Help] [Dependency Information]
Object Name: | OKL_LS_RT_FTR_SETS_ALL_B |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_LS_RT_FTR_SETS_ALL_B |
Subobject Name: | |
Status: | VALID |
DEFINITION:
A grouping of lease rate factors based upon certian common attributes. Specifically, the Payment Frequency, Payment in Advance or Arrears, and the Rate. The list of identifying attributes is likely to grow in future releases of the product. In OLM, a Lease Rate Set is synonymous with a Rate Card.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_LS_RT_FCTR_SETS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | NAME |
OKL_LS_RT_FTR_SETS_ALL_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKL_LS_RT_FTR_SETS_ALL_B_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
NAME
ORG_ID |
OKL_LS_RT_FTR_SETS_ALL_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RATE |
OKL_LS_RT_FTR_SETS_ALL_B_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | START_DATE |
OKL_LS_RT_FTR_SETS_ALL_B_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | END_DATE |
OKL_LS_RT_FTR_SETS_ALL_B_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LRS_TYPE_CODE |
OKL_LS_RT_FTR_SETS_ALL_B_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | END_OF_TERM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
ARREARS_YN | VARCHAR2 | (3) | Yes | The state of payments being made, i.e are payment being made in arrears (Yes) or advance (No). |
START_DATE | DATE | The date on which the Lease Rate Set becomes active. | ||
END_DATE | DATE | The date on which the Lease Rate Set becomes inactive. | ||
PDT_ID | NUMBER | Not currently in use. | ||
TRY_ID | NUMBER | Not currently in use. | ||
FRQ_CODE | VARCHAR2 | (30) | Yes | The payment frequency based upon which lease rate factors are computed. |
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 | |
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 | |
RATE | NUMBER | For Internal Use Only | ||
NAME | VARCHAR2 | (150) | Lease Rate Set (Rate Card) name. | |
STS_CODE | VARCHAR2 | (30) | Status Code. Lookup Type "OKL_PRC_STATUS" | |
ORG_ID | NUMBER | Organization Id | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
LRS_TYPE_CODE | VARCHAR2 | (30) | Lease Rate Set Type. Lookup Type "OKL_LRS_TYPES" | |
END_OF_TERM_ID | NUMBER | End of Term Option identifier | ||
ORIG_RATE_SET_ID | NUMBER | LRS Identifier from which this LRS is duplicated |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, OBJECT_VERSION_NUMBER
, ARREARS_YN
, START_DATE
, END_DATE
, PDT_ID
, TRY_ID
, FRQ_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, RATE
, NAME
, STS_CODE
, ORG_ID
, CURRENCY_CODE
, LRS_TYPE_CODE
, END_OF_TERM_ID
, ORIG_RATE_SET_ID
FROM OKL.OKL_LS_RT_FTR_SETS_ALL_B;
OKL.OKL_LS_RT_FTR_SETS_ALL_B does not reference any database object
OKL.OKL_LS_RT_FTR_SETS_ALL_B is referenced by following:
|
|
|