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: GME.GME_BATCH_STEP_DEP_MIG

Object Details

Object Name:	GME_BATCH_STEP_DEP_MIG
Object Type:	TABLE
Owner:	GME
FND Design Data:	GME.GME_BATCH_STEP_DEP_MIG
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GME_BATCH_STEP_DEP_MIG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ATTRIBUTE19	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE21	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE22	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE23	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE24	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE25	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE26	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE27	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE28	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE29	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE30	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Category
BATCH_ID	NUMBER	(10)	Yes	Surrogate key to the batch.
BATCHSTEP_ID	NUMBER	(15)	Yes	Number of the batch step.
DEP_TYPE	NUMBER	(5)	Yes	Dependency type.1 - Start to Start; used for scheduling steps. The dependent can step can start at the same time as the step it is dependent plus the delay.0 - Finish to Star
DEP_STEP_ID	NUMBER	(15)	Yes	Batch step number of the dependent step.
REWORK_CODE	VARCHAR2	(4)		Rework reason code, not currently used. NOTE: This data is not used for any functionality therefore, it is hidden in the folder but will remain in the database and remove any vali
STANDARD_DELAY	NUMBER		Yes	Standard period from start or end depending on the dep_type of dep_step_no to this step, in hours.
MIN_DELAY	NUMBER			Minimum period from start of dep_step_no to this step, in hours. NOTE: This data is not used for any functionality therefore, it is hidden in the folder but will remain in the da
MAX_DELAY	NUMBER			Maximum period from start of dep_step_no to this step, in hours.NOTE: This data is not used for any functionality therefore, it is hidden in the folder but will remain in the data
TRANSFER_QTY	NUMBER			Dependent step output required before this step can start. Currently not used; however, customers have requested this functionality supported.
TRANSFER_UM	VARCHAR2	(4)		Unit of measure in which transfer_qty is expressed. Currently not used; however, customers have requested this functionality supported. Used in conjunction with transfer_qty
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Columns
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Columns
CREATION_DATE	DATE		Yes	Standard WHO Columns
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Columns
TRANSFER_PERCENT	NUMBER			Default is 100 percent. Defined as Null since it is a new column but the business rule requires a value. Percentage of the step quantity output transferred to the dependent step.
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Flexfield
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Flexfield
CHARGEABLE_IND	NUMBER	(5)		Indicates that the dependency should be applied to the charges

Query Text

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


SELECT ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      BATCH_ID
,      BATCHSTEP_ID
,      DEP_TYPE
,      DEP_STEP_ID
,      REWORK_CODE
,      STANDARD_DELAY
,      MIN_DELAY
,      MAX_DELAY
,      TRANSFER_QTY
,      TRANSFER_UM
,      TEXT_CODE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      TRANSFER_PERCENT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      CHARGEABLE_IND
FROM GME.GME_BATCH_STEP_DEP_MIG;

Dependencies

[top of page]

GME.GME_BATCH_STEP_DEP_MIG does not reference any database object

GME.GME_BATCH_STEP_DEP_MIG is referenced by following:

APPS: GME_BATCH_STEP_DEP_MIG