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

VIEW: APPS.OKI_HSTATUS_DTL_V

Object Details
Object Name: OKI_HSTATUS_DTL_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID


This view maintains history of status changes for a contract ,like date on which status was changed, reason for status change etc.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CHR_ID NUMBER
Yes Internal idenitifer for the original contract
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract number
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier
COMPLETE_K_NUMBER VARCHAR2 (241)
Complete Contract Number
STATUS_CHANGE_DATE DATE
Yes Status Change Date
CONTRACT_VERSION VARCHAR2 (24) Yes Contract Version
STATUS_CODE VARCHAR2 (30)
Status Code
CHANGE_REASON_CODE VARCHAR2 (30)
Change Reason code
CHANGE_REASON VARCHAR2 (80)
Change Reason
TRN_CODE VARCHAR2 (30)
Termination CodeTermination code of the original contract
COMMENTS VARCHAR2 (4000)
Comments
CHANGE_USER VARCHAR2 (100) Yes
CHANGE_PERSON VARCHAR2 (575)
EMAIL_ADDRESS VARCHAR2 (2000)
E-Mail Address
Query Text

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


SELECT CHR_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      COMPLETE_K_NUMBER
,      STATUS_CHANGE_DATE
,      CONTRACT_VERSION
,      STATUS_CODE
,      CHANGE_REASON_CODE
,      CHANGE_REASON
,      TRN_CODE
,      COMMENTS
,      CHANGE_USER
,      CHANGE_PERSON
,      EMAIL_ADDRESS
FROM APPS.OKI_HSTATUS_DTL_V;

Dependencies

[top of page]

APPS.OKI_HSTATUS_DTL_V references the following:

SchemaAPPS
PL/SQL PackageBIS_COMMON_PARAMETERS - show dependent code
SynonymFND_LOOKUP_VALUES
SynonymFND_USER
SynonymHZ_PARTIES
SynonymOKC_K_HISTORY_B
SynonymOKC_K_HISTORY_TL
PL/SQL PackageOKC_UTIL - show dependent code
ViewOKI_SRM_006_V

APPS.OKI_HSTATUS_DTL_V is not referenced by any database object