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_JOB_RUN_DTL

Object Details

Object Name:	OKI_JOB_RUN_DTL
Object Type:	TABLE
Owner:	OKI
Subobject Name:
Status:	VALID

Incremental data load run details

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKI_JOB_RUN_DTL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	JOB_RUN_ID ACTION_FLAG CHR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
JOB_RUN_ID	NUMBER			job run id
CHR_ID	NUMBER			Contract header id
ACTION_FLAG	VARCHAR2	(1)		Action flag
CREATION_DATE	DATE		Yes	standard who column
CREATED_BY	NUMBER	(15)	Yes	standard who column
LAST_UPDATE_DATE	DATE		Yes	standard who column
LAST_UPDATED_BY	NUMBER	(15)		standard who column
SECURITY_GROUP_ID	NUMBER			Used for application hosting.
REQUEST_ID	NUMBER	(15)		Concurrent Manager audit column.
SOB_ID	NUMBER	(15)		Accounting Books ID
PERIOD_SET_NAME	VARCHAR2	(15)		Accounting calendar name
ACCOUNTED_PERIOD_TYPE	VARCHAR2	(15)		Accounting period type
FUNC_CURRENCY	VARCHAR2	(15)		Functional currency
CONVERSION_DATE	DATE			Conversion date
TRX_FUNC_RATE	NUMBER			The conversion rate from the transactional currency to the functional currency
TRX_BASE_RATE	NUMBER			The conversion rate from the function currency to the base currency
MAJOR_VERSION	NUMBER			Major version number
MINOR_VERSION	NUMBER			Minor version number

Query Text

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


SELECT JOB_RUN_ID
,      CHR_ID
,      ACTION_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SECURITY_GROUP_ID
,      REQUEST_ID
,      SOB_ID
,      PERIOD_SET_NAME
,      ACCOUNTED_PERIOD_TYPE
,      FUNC_CURRENCY
,      CONVERSION_DATE
,      TRX_FUNC_RATE
,      TRX_BASE_RATE
,      MAJOR_VERSION
,      MINOR_VERSION
FROM OKI.OKI_JOB_RUN_DTL;

Dependencies

[top of page]

OKI.OKI_JOB_RUN_DTL does not reference any database object

OKI.OKI_JOB_RUN_DTL is referenced by following:

APPS: OKI_JOB_RUN_DTL