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: OTA.OTA_BATCH_RANGES

Object Details

Object Name:	OTA_BATCH_RANGES
Object Type:	TABLE
Owner:	OTA
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_BATCH_RANGES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_SOURCE_CD RANGE_STATUS_CD BATCH_ACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RANGE_ID	NUMBER	(15)	Yes	Range Id is used to uniquely identify a range to be processed.
BATCH_ACTION_ID	NUMBER	(15)	Yes	Batch Action Id is used to uniquely identify the batch to be processed.
RANGE_STATUS_CD	VARCHAR2	(30)	Yes	Range Status Cd is used to identify the processing status of a particular range
STARTING_PERSON_ACTION_ID	NUMBER	(15)	Yes	Starting Person Action Id is used to identify the starting person action id in a range to be processed
ENDING_PERSON_ACTION_ID	NUMBER	(15)	Yes	Ending Person Action Id is used to identify the ending person action id in a range to be processed
BATCH_SOURCE_CD	VARCHAR2	(30)	Yes	Batch Source Cd is used to identify the concurrent program source of a range to be processed.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object Version Number is used to identify the version number of the current record.
CREATED_BY	NUMBER	(15)		Created By is used to identify the user id of the person created the current record.
CREATION_DATE	DATE			Creation Date is used to identify the date of creation of the current record.
LAST_UPDATE_DATE	DATE			Last Update Date is used to identify the date at which the current record has been last modified.
LAST_UPDATED_BY	NUMBER	(15)		Last Updated By is used to identify the user id of the person who last modified the current record.
LAST_UPDATE_LOGIN	NUMBER	(15)		Last Update Login is used to identify the login id of the person who last modified the current record

Query Text

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


SELECT RANGE_ID
,      BATCH_ACTION_ID
,      RANGE_STATUS_CD
,      STARTING_PERSON_ACTION_ID
,      ENDING_PERSON_ACTION_ID
,      BATCH_SOURCE_CD
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM OTA.OTA_BATCH_RANGES;

Dependencies

[top of page]

OTA.OTA_BATCH_RANGES does not reference any database object

OTA.OTA_BATCH_RANGES is referenced by following:

OTA: OTA_BATCH_RANGES#