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: OKC.OKC_KEXP_REPORT

Object Details

Object Name:	OKC_KEXP_REPORT
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_KEXP_REPORT
Subobject Name:
Status:	VALID

This is a temporary table to store the contract search results initiated from contract search screen. These results are later used by discoverer business views to generate reports.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_KEXP_REPORT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONTRACT_HEADER_ROWID REPORT_ID
OKC_KEXP_REPORT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPORT_ID

Columns

Name	Datatype	Length	Comments
CONTRACT_HEADER_ROWID	ROWID	(10)	This column is intended to store the rowids from Contract header, for the search results.
REPORT_ID	NUMBER		This column is intended to store the report run number. Incremented for every search report made from the contracts search form.
REPORT_DATE	DATE		This column stores the report run date, for cleanup purpose. This will be passed as a parameter to a concurrent program to cleanup the records in the temporary table.

Query Text

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


SELECT CONTRACT_HEADER_ROWID
,      REPORT_ID
,      REPORT_DATE
FROM OKC.OKC_KEXP_REPORT;

Dependencies

[top of page]

OKC.OKC_KEXP_REPORT does not reference any database object

OKC.OKC_KEXP_REPORT is referenced by following:

OKC: OKC_KEXP_REPORT#