VIEW: APPS.GMO_BATCH_STEPS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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