[Home] [Help]
[Dependency Information]
Object Name: | OKI_EXP_NOT_RENEWED_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
A view over OKI_EXP_NOT_RENEWED, containing language specific information.
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. |
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
FROM APPS.OKI_EXP_NOT_RENEWED_V;
APPS.OKI_EXP_NOT_RENEWED_V is not referenced by any database object
|
|
|