[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
Name | Datatype | Length | Mandatory | 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. |
Cut, paste (and edit) the following text to query this object:
SELECT CONTRACT_HEADER_ROWID
, REPORT_ID
, REPORT_DATE
FROM OKC.OKC_KEXP_REPORT;
OKC.OKC_KEXP_REPORT does not reference any database object
OKC.OKC_KEXP_REPORT is referenced by following:
|
|
|