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_STEPS_MIG

Object Details

Object Name:	GME_BATCH_STEPS_MIG
Object Type:	TABLE
Owner:	GME
FND Design Data:	GME.GME_BATCH_STEPS_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_STEPS_MIG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TERMINATED_IND	NUMBER	(1)		Indicates if the step has been terminated. 1 - Yes 0 - No
STEP_QTY_UM	VARCHAR2	(3)	Yes	Step Quantity UOM
MASS_REF_UM	VARCHAR2	(3)		UOM in MASS
VOLUME_REF_UM	VARCHAR2	(3)		UOM in VOLUME
MAX_STEP_CAPACITY_UM	VARCHAR2	(3)		Capacity UOM
STEP_QTY_UOM	VARCHAR2	(4)		Obsolete in R12. New column is step_qty_um.
MAX_STEP_CAPACITY_UOM	VARCHAR2	(4)		Obsolete in R12. New column is max_step_capacity_um.
MASS_REF_UOM	VARCHAR2	(4)		Obsolete in R12. New column is mass_ref_um.
VOLUME_REF_UOM	VARCHAR2	(4)		Obsolete in R12. New column is volume_ref_um.
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 proce
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
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
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.
BACKFLUSH_QTY	NUMBER			not currently used
PLAN_START_DATE	DATE			Based on batch start date and any DEP
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, pro
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
PLAN_CHARGES	NUMBER			Calculated at the time the step is created.
ACTUAL_CHARGES	NUMBER			Can change when a step is scaled
PLAN_MASS_QTY	NUMBER			Planned Step quantity converted to the mass reference uom.
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

Query Text

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


SELECT TERMINATED_IND
,      STEP_QTY_UM
,      MASS_REF_UM
,      VOLUME_REF_UM
,      MAX_STEP_CAPACITY_UM
,      STEP_QTY_UOM
,      MAX_STEP_CAPACITY_UOM
,      MASS_REF_UOM
,      VOLUME_REF_UOM
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      QUALITY_STATUS
,      MINIMUM_TRANSFER_QTY
,      BATCH_ID
,      BATCHSTEP_ID
,      ROUTINGSTEP_ID
,      BATCHSTEP_NO
,      OPRN_ID
,      PLAN_STEP_QTY
,      ACTUAL_STEP_QTY
,      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
,      PLAN_CHARGES
,      ACTUAL_CHARGES
,      PLAN_MASS_QTY
,      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
FROM GME.GME_BATCH_STEPS_MIG;

Dependencies

[top of page]

GME.GME_BATCH_STEPS_MIG does not reference any database object

GME.GME_BATCH_STEPS_MIG is referenced by following:

APPS: GME_BATCH_STEPS_MIG