[Home] [Help] [Dependency Information]
Object Name: | OKI_RENEWAL_AGING |
---|---|
Object Type: | TABLE |
Owner: | OKI |
FND Design Data: | OKI.OKI_RENEWAL_AGING |
Subobject Name: | |
Status: | VALID |
Holds the summary information about the aging of renewals, by period, operating unit, and customer.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKI_RENEWAL_AGING_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKI_RENEWAL_AGING_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERIOD_NAME
PERIOD_SET_NAME AUTHORING_ORG_ID CUSTOMER_PARTY_ID SCS_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | The internal identifier for the row. | |
PERIOD_NAME | VARCHAR2 | (15) | Yes | The name from General Ledger for the period of this information. |
PERIOD_SET_NAME | VARCHAR2 | (15) | Yes | The name of the General Ledger period set used to determine valid periods. |
PERIOD_TYPE | VARCHAR2 | (15) | The type of General Ledger period used for this information. | |
AUTHORING_ORG_ID | NUMBER | Yes | The internal identifier of the operating unit in which the contract was authored. | |
AUTHORING_ORG_NAME | VARCHAR2 | (240) | The name of the operating unit in which the contract was authored. | |
CUSTOMER_PARTY_ID | NUMBER | Yes | The internal party identifier of the contract customer. | |
CUSTOMER_NAME | VARCHAR2 | (360) | The name of the customer in the contract. | |
SCS_CODE | VARCHAR2 | (30) | The category (sub-class) code for the contract. | |
AGE_GROUP1 | NUMBER | The first renewal aging bucket, holds the value of contracts in that bucket. | ||
AGE_GROUP2 | NUMBER | The second renewal aging bucket, holds the value of contracts in that bucket. | ||
AGE_GROUP3 | NUMBER | The third renewal aging bucket, holds the value of contracts in that bucket. | ||
AGE_GROUP4 | NUMBER | The fourth renewal aging bucket, holds the value of contracts in that bucket. | ||
REQUEST_ID | NUMBER | (15) | Concurrent Manager audit column. | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Manager audit column. | |
PROGRAM_ID | NUMBER | (15) | Concurrent Manager audit column. | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Manager audit column. | ||
SECURITY_GROUP_ID | NUMBER | Used for application hosting. |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, PERIOD_NAME
, PERIOD_SET_NAME
, PERIOD_TYPE
, AUTHORING_ORG_ID
, AUTHORING_ORG_NAME
, CUSTOMER_PARTY_ID
, CUSTOMER_NAME
, SCS_CODE
, AGE_GROUP1
, AGE_GROUP2
, AGE_GROUP3
, AGE_GROUP4
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SECURITY_GROUP_ID
FROM OKI.OKI_RENEWAL_AGING;
OKI.OKI_RENEWAL_AGING does not reference any database object
OKI.OKI_RENEWAL_AGING is referenced by following:
|
|
|