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

VIEW: OKS.OKS_HEADERS_TEMP#

Object Details
Object Name: OKS_HEADERS_TEMP#
Object Type: VIEW
Owner: OKS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CHR_ID NUMBER

CONTRACT_NUMBER VARCHAR2 (120)
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
CASCADE_SELECTION VARCHAR2 (1)
GLOBAL_START_DATE DATE

GLOBAL_END_DATE DATE

GLOBAL_PRICE_NEGOTIATED NUMBER

GLOBAL_STATUS VARCHAR2 (30)
GLOBAL_NEW_STATUS_CODE VARCHAR2 (30)
GLOBAL_REASON_CODE VARCHAR2 (30)
GLOBAL_COMMENTS VARCHAR2 (2000)
CONTRACT_START_DATE DATE

CONTRACT_END_DATE DATE

CONTRACT_STATUS VARCHAR2 (30)
CONTRACT_AMOUNT NUMBER

SAVED_FLAG VARCHAR2 (1)
COMMIT_FLAG VARCHAR2 (1)
REQUEST_ID NUMBER

CHR_ID_CHAR VARCHAR2 (80)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9)
SEARCH_IN VARCHAR2 (30)
SEARCH_STR VARCHAR2 (2000)
SORT_BY VARCHAR2 (30)
SORT_BY_ORDER VARCHAR2 (10)
Query Text

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


SELECT CHR_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      CASCADE_SELECTION
,      GLOBAL_START_DATE
,      GLOBAL_END_DATE
,      GLOBAL_PRICE_NEGOTIATED
,      GLOBAL_STATUS
,      GLOBAL_NEW_STATUS_CODE
,      GLOBAL_REASON_CODE
,      GLOBAL_COMMENTS
,      CONTRACT_START_DATE
,      CONTRACT_END_DATE
,      CONTRACT_STATUS
,      CONTRACT_AMOUNT
,      SAVED_FLAG
,      COMMIT_FLAG
,      REQUEST_ID
,      CHR_ID_CHAR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SEARCH_IN
,      SEARCH_STR
,      SORT_BY
,      SORT_BY_ORDER
FROM OKS.OKS_HEADERS_TEMP#;

Dependencies

[top of page]

OKS.OKS_HEADERS_TEMP# references the following:

SchemaOKS
TableOKS_HEADERS_TEMP
OKS.OKS_HEADERS_TEMP# is referenced by following:

SchemaAPPS
SynonymOKS_HEADERS_TEMP