DBA Data[Home] [Help] [Dependency Information]

TABLE: GME.GME_BATCH_STEP_DEPENDENCIES

Object Details
Object Name: GME_BATCH_STEP_DEPENDENCIES
Object Type: TABLE
Owner: GME
FND Design Data: TableGME.GME_BATCH_STEP_DEPENDENCIES
Subobject Name:
Status: VALID


This table contains data about dependencies between batch steps. For example, the start of a step can be dependent on the completion of a previous step


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GME_BATCH_STEP_DEPENDENCIES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
ColumnBATCHSTEP_ID
ColumnDEP_STEP_ID
Columns
Name Datatype Length Mandatory Comments
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 Start; defaultStart to Start is a new dep_type. The migration needs to verify non-zero values or the value 1 does not exist and inform the user the value 1 takes on business rules for the new release.
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 validations.
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 database and remove any validations.
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 database and remove any validations.
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. Must be > or = 0.
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
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
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 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
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      CHARGEABLE_IND
FROM GME.GME_BATCH_STEP_DEPENDENCIES;

Dependencies

[top of page]

GME.GME_BATCH_STEP_DEPENDENCIES does not reference any database object

GME.GME_BATCH_STEP_DEPENDENCIES is referenced by following:

SchemaAPPS
SynonymGME_BATCH_STEP_DEPENDENCIES
SynonymGME_BT_STEP_DEPENDENCS