[Home] [Help] [Dependency Information]
Object Name: | GME_BATCH_STEP_ACTIVITIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GME.GME_BATCH_STEP_ACTIVITIES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Supplementary view based on table gme_batch_step_activities
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (10) | Yes | Batch Identifier FK to the GME_BATCH_HEADER table |
ACTIVITY | VARCHAR2 | (16) | Yes | The activity performed in the operation. FM_ACTV_MST - FK |
BATCHSTEP_ID | NUMBER | (15) | Yes | The number of the batch step performing the operation. FK - GME_BATCH_STEPS |
BATCHSTEP_ACTIVITY_ID | NUMBER | (10) | Yes | Surrogate key to the batch step line. sequence - GME_BATCHSTEP_ACTIVITY_S |
OPRN_LINE_ID | NUMBER | (10) | FK to the operation activity line, GMD_OPERATIONS_ACTIVITIES. Null if a activity was inserted for the batch and not defined in the routing associated with the recipe | |
OFFSET_INTERVAL | NUMBER | Yes | Time offset in hours from step start to this activity. Must be => 0. | |
PLAN_START_DATE | DATE | Planned start date/time for this activity. Planned start date of the step plus the offset interval. If an activity is used more than once for a step, the plan_start_date is used to sequence these activities in the step | ||
ACTUAL_START_DATE | DATE | Actual start date/time for this activity. Null on creation. Updated when the step is released, default to step actual step time but can be overridden at release time. | ||
PLAN_CMPLT_DATE | DATE | Planned completion date/time for this activity. The planned completion date of the last resource performing the activity, stored in GME_BATCH_STEP_RESOURCES. | ||
ACTUAL_CMPLT_DATE | DATE | Actual completion date/time for this activity. Null on creation. Updated with the batch step is certified, default to the step actual completion date. | ||
PLAN_START_DATE_DT | VARCHAR2 | (4000) | Planned start date in user display format | |
ACTUAL_START_DATE_DT | VARCHAR2 | (4000) | Actual start date in user display format | |
PLAN_CMPLT_DATE_DT | VARCHAR2 | (4000) | Planned completion date in user display format | |
ACTUAL_CMPLT_DATE_DT | VARCHAR2 | (4000) | Actual completion date in user display format | |
PLAN_ACTIVITY_FACTOR | NUMBER | Derived from GMD_RECIPE_ACTIVITIES since activity factor can be overridden at the recipe level from the operation. Must be => 0, defaults to 1. | ||
ACTUAL_ACTIVITY_FACTOR | NUMBER | Default from planned_activity_factor and can be overridden. Must be => 0, defaults to 1. | ||
DELETE_MARK | NUMBER | (5) | Yes | Standard: 0 = Active record (default)1 = Marked for (logical) deletion |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
SEQUENCE_DEPENDENT_IND | NUMBER | (5) | Allow user to select sequence dependent activities. 1 - Activity is Sequence dependent, Anything else - Not sequence dependent' | |
MAX_BREAK | NUMBER | Defines the maximum amount of time in hours, that the activity can break before restarting again. NULL implies that there will be no limit on the break if the indicator is set to yes. | ||
BREAK_IND | NUMBER | This will indicate that the activity will have a break in processing. The values acceptable will be 0(no) or 1(yes). | ||
MATERIAL_IND | NUMBER | This indicates if the Activity in that operation processes any material(consumes or yields or both). This is carried forward from GMD definitions. 0(NO) or 1(YES). It is assumed that NULL is the same as 0(NO). | ||
BATCHSTEP_NO | NUMBER | (10) | Yes | Batch Step Number |
OPERATION_NO | VARCHAR2 | (16) | Yes | Operation |
OPERATION_VERS | NUMBER | (5) | Yes | Operation Version |
ACTIVITY_DESC | VARCHAR2 | (40) | Yes | Activity Description |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, ACTIVITY
, BATCHSTEP_ID
, BATCHSTEP_ACTIVITY_ID
, OPRN_LINE_ID
, OFFSET_INTERVAL
, PLAN_START_DATE
, ACTUAL_START_DATE
, PLAN_CMPLT_DATE
, ACTUAL_CMPLT_DATE
, PLAN_START_DATE_DT
, ACTUAL_START_DATE_DT
, PLAN_CMPLT_DATE_DT
, ACTUAL_CMPLT_DATE_DT
, PLAN_ACTIVITY_FACTOR
, ACTUAL_ACTIVITY_FACTOR
, DELETE_MARK
, TEXT_CODE
, SEQUENCE_DEPENDENT_IND
, MAX_BREAK
, BREAK_IND
, MATERIAL_IND
, BATCHSTEP_NO
, OPERATION_NO
, OPERATION_VERS
, ACTIVITY_DESC
FROM APPS.GME_BATCH_STEP_ACTIVITIES_V;
APPS.GME_BATCH_STEP_ACTIVITIES_V is not referenced by any database object
|
|
|