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

TABLE: GME.GME_BATCH_STEPS

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


Batch steps table. This table contains data about each step (operation) in a batch, such as the step status and planned and actual start and completion dates.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GME_BATCH_STEPS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCHSTEP_ID
GME_BATCH_STEPS_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
ColumnBATCHSTEP_NO
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (10) Yes Batch Identifier FK to the GME_BATCH_HEADER table.
BATCHSTEP_ID NUMBER (15) Yes Unique Identifier for Batch Steps
ROUTINGSTEP_ID NUMBER (10)
Reference to standard routing step for variance calculations. FK to FM_ROUT_DTL.
BATCHSTEP_NO NUMBER (10) Yes Batch step Identifier. Batch routing step number, defaults from fm_rout_dtl.
OPRN_ID NUMBER (10) Yes FK to the operation GMD_OPERATIONS, defaults from fm_rout_dtl. Stored for all batch steps. If a routing step is added to batch not originally defined to the recipe, the oprn_id is stored. Stored for steps not defined in routing.
PLAN_STEP_QTY NUMBER
Yes If scaling and auto-calculate step qty = On and formula is scalable, first scale materials next recalculate step qty using step material association if exist make GMD_ calculation function can be used by FM & PM - GMDif step dependencies exist, also consider what has flowed through from previous step - GMDif auto-calculate step qty is OFF then just scale routing step quantities.Note: If the planned qty in batch is changed, then the plan_step_qty is recalculated.
ACTUAL_STEP_QTY NUMBER

The actual is not stored when the step is created. Either a Null or zero is stored; will store the value stored today.
STEP_QTY_UOM VARCHAR2 (4)
Obsolete in R12. New column is step_qty_um.
BACKFLUSH_QTY NUMBER

not currently used
PLAN_START_DATE DATE

Based on batch start date and any dependencies
ACTUAL_START_DATE DATE

Updated at the time the step is released; defaults to system date but can be overridden; validates actual_start_date is batch start date; and after any step it is dependent on, provide a warning
DUE_DATE DATE
Yes no validations, Required step completion date/time.
PLAN_CMPLT_DATE DATE

Based on the step planned start date and plus the time required for step to complete
ACTUAL_CMPLT_DATE DATE

Updated at the time the system is certified. Defaults to system date/time and can be overridden.
STEP_CLOSE_DATE DATE

Updated at the time the step is closed; Defaults to system date/time and can be overridden.
STEP_STATUS NUMBER (5) Yes 0 = New, 1 = Pending, 2 = WIP, 3 = Completed, 4 = Closed, 5 = Cancelled
PRIORITY_CODE VARCHAR2 (4)
Not currently used
PRIORITY_VALUE NUMBER

Not currently used
DELETE_MARK NUMBER (5) Yes Standard: 0 = Active record (default)1 = Marked for (logical) deletion.
STEPRELEASE_TYPE NUMBER (5) Yes 1= Manual, 2 = Automatic
MAX_STEP_CAPACITY NUMBER

Calculate from GME_RESOURCES_DTL
MAX_STEP_CAPACITY_UOM VARCHAR2 (4)
Obsolete in R12. New column is max_step_capacity_um.
PLAN_CHARGES NUMBER

Calculated at the time the step is created.
ACTUAL_CHARGES NUMBER

Can change when a step is scaled
MASS_REF_UOM VARCHAR2 (4)
Obsolete in R12. New column is mass_ref_um.
PLAN_MASS_QTY NUMBER

Planned Step quantity converted to the mass reference uom.
VOLUME_REF_UOM VARCHAR2 (4)
Obsolete in R12. New column is volume_ref_um.
PLAN_VOLUME_QTY NUMBER

Planned Step quantity converted to the volume reference uom
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
ACTUAL_MASS_QTY NUMBER

Actual Step quantity converted to the mass reference uom.
ACTUAL_VOLUME_QTY NUMBER

Actual Step quantity converted to the volume reference uom
LAST_UPDATE_DATE DATE
Yes Standard WHO Columns
CREATION_DATE DATE
Yes Standard WHO Columns
CREATED_BY NUMBER (15) Yes Standard WHO Columns
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Columns
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Category
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
QUALITY_STATUS NUMBER (1)
This column is showing the requirement of sample for the step
MINIMUM_TRANSFER_QTY NUMBER

Minimum amount of material that must be produced at a given production operation and resource, that will be transferred to the next operation and resource before it can begin processing. This field is carried from GMD to GME
TERMINATED_IND NUMBER (1)
Indicates if the step has been terminated. 1 - Yes 0 - No
MASS_REF_UM VARCHAR2 (3)
UOM in MASS
MAX_STEP_CAPACITY_UM VARCHAR2 (3)
Capacity UOM
STEP_QTY_UM VARCHAR2 (3)
Step Quantity UOM
VOLUME_REF_UM VARCHAR2 (3)
UOM in VOLUME
Query Text

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


SELECT BATCH_ID
,      BATCHSTEP_ID
,      ROUTINGSTEP_ID
,      BATCHSTEP_NO
,      OPRN_ID
,      PLAN_STEP_QTY
,      ACTUAL_STEP_QTY
,      STEP_QTY_UOM
,      BACKFLUSH_QTY
,      PLAN_START_DATE
,      ACTUAL_START_DATE
,      DUE_DATE
,      PLAN_CMPLT_DATE
,      ACTUAL_CMPLT_DATE
,      STEP_CLOSE_DATE
,      STEP_STATUS
,      PRIORITY_CODE
,      PRIORITY_VALUE
,      DELETE_MARK
,      STEPRELEASE_TYPE
,      MAX_STEP_CAPACITY
,      MAX_STEP_CAPACITY_UOM
,      PLAN_CHARGES
,      ACTUAL_CHARGES
,      MASS_REF_UOM
,      PLAN_MASS_QTY
,      VOLUME_REF_UOM
,      PLAN_VOLUME_QTY
,      TEXT_CODE
,      ACTUAL_MASS_QTY
,      ACTUAL_VOLUME_QTY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      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
,      QUALITY_STATUS
,      MINIMUM_TRANSFER_QTY
,      TERMINATED_IND
,      MASS_REF_UM
,      MAX_STEP_CAPACITY_UM
,      STEP_QTY_UM
,      VOLUME_REF_UM
FROM GME.GME_BATCH_STEPS;

Dependencies

[top of page]

GME.GME_BATCH_STEPS does not reference any database object

GME.GME_BATCH_STEPS is referenced by following:

SchemaGME
ViewGME_BATCH_STEPS#