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

VIEW: APPS.OKS_ENT_K_STATUS_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


Lists all Statuses of the Contract


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER
Yes Organization Identifier
CONTRACT_ID NUMBER
Yes FK to Contract Header.
CONTRACT_NUMBER VARCHAR2 (120) Yes With CONTRACT_NUMBER_MODIFIER, used to uniquely identify a contract as a business entity.
CONTRACT_STATUS_CODE VARCHAR2 (30) Yes Contract Status Code
CONTRACT_STATUS_NAME VARCHAR2 (80) Yes Contract Status Name
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORG_ID
,      CONTRACT_ID
,      CONTRACT_NUMBER
,      CONTRACT_STATUS_CODE
,      CONTRACT_STATUS_NAME
FROM APPS.OKS_ENT_K_STATUS_V;

Dependencies

[top of page]

APPS.OKS_ENT_K_STATUS_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymOKC_K_HEADERS_ALL_B

APPS.OKS_ENT_K_STATUS_V is not referenced by any database object