[Home] [Help] [Dependency Information]
Object Name: | OKS_ENT_HDR_SUMMARY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKS.OKS_ENT_HDR_SUMMARY_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view can be used to get contract header level information for a contract and/or a customer.
This view should always be filtered using party_id or, contract_id
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTRACT_ID | NUMBER | Yes | Unique identifier of Contract. | |
CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contract (RFP,Proposal etc.) Legal Identifier. |
CONTRACT_NUMBER_MODIFIER | VARCHAR2 | (120) | A unique internal name for the contract number. Conbination of contract number and modifier are unique for a contract. | |
CONTRACT_AMOUNT | NUMBER | Contract Subtotal. | ||
CURRENCY_CODE | VARCHAR2 | (15) | Unique identifier of Currency code. Refers to CURRENCY_CODE in FND_CURRENCIES. | |
CONTRACT_STATUS_CODE | VARCHAR2 | (30) | Yes | Indicates status of Contract Header. Refers to Code in OKC_STATUSES_B. |
START_DATE_ACTIVE | DATE | The beginning of the active period, one second after midnight on the date indicated. | ||
END_DATE_ACTIVE | DATE | The end of the active period, one second before midnight on the date indicated. | ||
PARTY_ID | VARCHAR2 | (40) | Contract Customer Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT CONTRACT_ID
, CONTRACT_NUMBER
, CONTRACT_NUMBER_MODIFIER
, CONTRACT_AMOUNT
, CURRENCY_CODE
, CONTRACT_STATUS_CODE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, PARTY_ID
FROM APPS.OKS_ENT_HDR_SUMMARY_V;
|
|
|