[Home] [Help]
View: GMO_BATCH_STEPS_V
Product: | GMO - Manufacturing Execution System for Process Manufacturing |
Description: | |
Implementation/DBA Data: |
APPS.GMO_BATCH_STEPS_V
|
View Text
SELECT A.BATCH_ID
, C.BATCH_NO
, A.BATCHSTEP_ID
, A.BATCHSTEP_NO
, A.OPRN_ID
, A.PLAN_STEP_QTY
, A.ACTUAL_STEP_QTY
, NULL
, A.PLAN_START_DATE
, A.ACTUAL_START_DATE
, A.DUE_DATE
, A.PLAN_CMPLT_DATE
, A.ACTUAL_CMPLT_DATE
, A.STEP_CLOSE_DATE
, A.STEP_STATUS
, A.STEPRELEASE_TYPE
, A.MAX_STEP_CAPACITY
, NULL
, A.PLAN_CHARGES
, A.ACTUAL_CHARGES
, A.QUALITY_STATUS
, A.MINIMUM_TRANSFER_QTY
, A.TERMINATED_IND
, B.OPRN_NO
, B.OPRN_VERS
, B.OPRN_DESC
, B.OPRN_NO||'-'||B.OPRN_VERS
FROM GME_BATCH_STEPS A
, GMD_OPERATIONS_VL B
, GME_BATCH_HEADER C
WHERE A.OPRN_ID = B.OPRN_ID
AND A.BATCH_ID=C.BATCH_ID
Columns
Name |
BATCH_ID |
BATCH_NO |
BATCHSTEP_ID |
BATCHSTEP_NO |
OPRN_ID |
PLAN_STEP_QTY |
ACTUAL_STEP_QTY |
STEP_QTY_UM |
PLAN_START_DATE |
ACTUAL_START_DATE |
DUE_DATE |
PLAN_CMPLT_DATE |
ACTUAL_CMPLT_DATE |
STEP_CLOSE_DATE |
STEP_STATUS |
STEPRELEASE_TYPE |
MAX_STEP_CAPACITY |
MAX_STEP_CAPACITY_UM |
PLAN_CHARGES |
ACTUAL_CHARGES |
QUALITY_STATUS |
MINIMUM_TRANSFER_QTY |
TERMINATED_IND |
OPRN_NO |
OPRN_VERS |
OPRN_DESC |
OPERATION |