[Home] [Help] [Dependency Information]
Object Name: | OKI_RNW_BY_STS_DTL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKI.OKI_RNW_BY_STS_DTL_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Summarized information about renewal contracts, by status and General Ledger period.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_SET_NAME | VARCHAR2 | (15) | 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. | |
PERIOD_NAME | VARCHAR2 | (15) | The name from General Ledger for the period of this information. | |
AUTHORING_ORG_ID | NUMBER | The internal identifier of the operating unit in which the contract was authored. | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | The name of the operating unit in which the contract was authored. | |
CATEGORY_CODE | VARCHAR2 | (30) | The code of the contract category. | |
CATEGORY_MEANING | VARCHAR2 | (90) | The user description for the contract category. | |
RENEWAL_PROCESS_CODE | VARCHAR2 | (8) | The renewal status category code, used to link to the summary. | |
STATUS_CODE | VARCHAR2 | (30) | The code value representing the status of the contract. | |
STATUS_MEANING | VARCHAR2 | (90) | The external description of the status of the contract. | |
CONTRACT_COUNT | NUMBER | The count of contracts. | ||
BASE_CONTRACT_AMOUNT | NUMBER | The contract value, in the base currency. | ||
BASE_CURRENCY_CODE | VARCHAR2 | (4000) | The currency code of the base currency. |
Cut, paste (and edit) the following text to query this object:
SELECT PERIOD_SET_NAME
, PERIOD_TYPE
, PERIOD_NAME
, AUTHORING_ORG_ID
, ORGANIZATION_NAME
, CATEGORY_CODE
, CATEGORY_MEANING
, RENEWAL_PROCESS_CODE
, STATUS_CODE
, STATUS_MEANING
, CONTRACT_COUNT
, BASE_CONTRACT_AMOUNT
, BASE_CURRENCY_CODE
FROM APPS.OKI_RNW_BY_STS_DTL_V;
APPS.OKI_RNW_BY_STS_DTL_V is not referenced by any database object
|
|
|