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: OKI.OKI_REFRESHS

Object Details

Object Name:	OKI_REFRESHS
Object Type:	TABLE
Owner:	OKI
FND Design Data:	OKI.OKI_REFRESHS
Subobject Name:
Status:	VALID

This table holds the data about the the latest run of a concurrent manager program which refreshed a table in OKI.
There will be only one row for each table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_NAME	VARCHAR2	(60)	Yes	The name of the refreshed object.
MV_YN	VARCHAR2	(1)	Yes	Whether or not the refreshed object is a materialized view.
REQUEST_ID	NUMBER	(15)		Concurrent Manager audit column.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Manager audit column.
PROGRAM_ID	NUMBER	(15)		Concurrent Manager audit column.
PROGRAM_UPDATE_DATE	DATE			Concurrent Manager audit column.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	A number used to track the version of the row.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
SECURITY_GROUP_ID	NUMBER			Used for application hosting.
JOB_RUN_ID	NUMBER			Job run id of the last incremental refresh

Query Text

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


SELECT OBJECT_NAME
,      MV_YN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      JOB_RUN_ID
FROM OKI.OKI_REFRESHS;

Dependencies

[top of page]

OKI.OKI_REFRESHS does not reference any database object

OKI.OKI_REFRESHS is referenced by following:

APPS: OKI_LOAD_ENR_PVT - show dependent code; OKI_LOAD_ETR_PVT - show dependent code; OKI_LOAD_FBO_PVT - show dependent code; OKI_LOAD_OKV_PVT - show dependent code; OKI_LOAD_RAG_PVT - show dependent code; OKI_LOAD_RBK_PVT - show dependent code; OKI_LOAD_RBS_PVT - show dependent code; OKI_LOAD_SGR_PVT - show dependent code; OKI_LOAD_TNK_PVT - show dependent code; OKI_LOAD_WBC_PVT - show dependent code; OKI_LOAD_YRA_PVT - show dependent code; OKI_REFRESHS; OKI_REFRESH_PVT - show dependent code