eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OKS.OKS_HEADERS_TEMP

Object Details

Object Name:	OKS_HEADERS_TEMP
Object Type:	TABLE
Owner:	OKS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length
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 does not reference any database object

OKS.OKS_HEADERS_TEMP is referenced by following:

OKS: OKS_HEADERS_TEMP#