DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKS_ENT_HDR_SUMMARY_V

Object Details
Object Name: OKS_ENT_HDR_SUMMARY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKS.OKS_ENT_HDR_SUMMARY_V
Subobject Name:
Status: VALID

View Type

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


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.OKS_ENT_HDR_SUMMARY_V references the following:

SchemaAPPS
SynonymOKC_K_HEADERS_ALL_B
SynonymOKC_K_PARTY_ROLES_B
SynonymOKC_SUBCLASSES_B
APPS.OKS_ENT_HDR_SUMMARY_V is referenced by following:

SchemaAPPS
Package BodyCSC_SERVICE_KEY_PVT - show dependent code
Package BodySR_UWQ_INTEG - show dependent code