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

VIEW: APPS.GME_BATCH_STEPS_V

Object Details
Object Name: GME_BATCH_STEPS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGME.GME_BATCH_STEPS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Supplementary view based on table gme batch steps


[View Source]

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.
OPERATION_NO VARCHAR2 (16) Yes Operation
OPERATION_VERS NUMBER (5) Yes Operation version
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.
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.
PLAN_START_DATE_DT VARCHAR2 (4000)
Plan Start Date in user display format
ACTUAL_START_DATE_DT VARCHAR2 (4000)
Actual Start Date in user display format
DUE_DATE_DT VARCHAR2 (4000)
due date in user display format
PLAN_CMPLT_DATE_DT VARCHAR2 (4000)
plan completion date in user display format
ACTUAL_CMPLT_DATE_DT VARCHAR2 (4000)
Actual Completion Date in user display format
STEP_CLOSE_DATE_DT VARCHAR2 (4000)
Step Close Date in user display format
STEP_STATUS NUMBER (5) Yes 0 = New, 1 = Pending, 2 = WIP, 3 = Completed, 4 = Closed, 5 = Cancelled
STEP_STATUS_MEANING VARCHAR2 (80) Yes Step Status code resolved using Lookup meaning
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
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
STEP_QTY_UM VARCHAR2 (3)
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
TERMINATED VARCHAR2 (4000)
Terminated Indicator
Query Text

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


SELECT BATCH_ID
,      BATCHSTEP_ID
,      ROUTINGSTEP_ID
,      BATCHSTEP_NO
,      OPRN_ID
,      OPERATION_NO
,      OPERATION_VERS
,      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
,      PLAN_START_DATE_DT
,      ACTUAL_START_DATE_DT
,      DUE_DATE_DT
,      PLAN_CMPLT_DATE_DT
,      ACTUAL_CMPLT_DATE_DT
,      STEP_CLOSE_DATE_DT
,      STEP_STATUS
,      STEP_STATUS_MEANING
,      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
,      QUALITY_STATUS
,      MINIMUM_TRANSFER_QTY
,      TERMINATED_IND
,      STEP_QTY_UM
,      MASS_REF_UM
,      VOLUME_REF_UM
,      MAX_STEP_CAPACITY_UM
,      TERMINATED
FROM APPS.GME_BATCH_STEPS_V;

Dependencies

[top of page]

APPS.GME_BATCH_STEPS_V references the following:

SchemaAPPS
PL/SQL PackageFND_DATE - show dependent code
PL/SQL PackageFND_MESSAGE - show dependent code
PL/SQL PackageFND_TIMEZONES - show dependent code
ViewGEM_LOOKUPS
SynonymGMD_OPERATIONS
SynonymGME_BATCH_STEPS
APPS.GME_BATCH_STEPS_V is referenced by following:

SchemaAPPS
ViewGME_BATCH_STEP_ACTIVITIES_V
Package BodyGMO_CBR_GRP - show dependent code