[Home] [Help] [Dependency Information]
Object Name: | OKI_EXP_NOT_RENEWED |
---|---|
Object Type: | TABLE |
Owner: | OKI |
FND Design Data: | OKI.OKI_EXP_NOT_RENEWED |
Subobject Name: | |
Status: | VALID |
This table holds summarized information about the value and count of contract lines that have expired without being renewed, by several dimensions such as period, operating unit, and customer.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKI_EXP_NOT_RENEWED_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKI_EXP_NOT_RENEWED_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERIOD_NAME
PERIOD_SET_NAME AUTHORING_ORG_ID CUSTOMER_PARTY_ID SCS_CODE CONTACT_ID |
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. | |
CONTACT_ID | VARCHAR2 | (40) | The internal identifier for the contract contact. | |
SALESREP_NAME | VARCHAR2 | (240) | The name of the sales representative. | |
SCS_CODE | VARCHAR2 | (30) | The category (sub-class) code for the contract. | |
CONTRACT_COUNT | NUMBER | The count of contracts expired and not renewed. | ||
BASE_LOST_AMOUNT | NUMBER | The amount lost (not renewed), in the base currency. | ||
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
, CONTACT_ID
, SALESREP_NAME
, SCS_CODE
, CONTRACT_COUNT
, BASE_LOST_AMOUNT
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SECURITY_GROUP_ID
FROM OKI.OKI_EXP_NOT_RENEWED;
OKI.OKI_EXP_NOT_RENEWED does not reference any database object
OKI.OKI_EXP_NOT_RENEWED is referenced by following:
|
|
|