[Home] [Help]
View: GMD_QC_E_WIP_SAMPLE_DTLS_V
View Text
SELECT GSMP.SAMPLE_ID SAMPLE_ID
, BATCHHEADER.BATCH_NO
, BATCHHEADER.ORGANIZATION_ID
, FORMULAMST.FORMULA_NO
, FORMULAMST.FORMULA_VERS
, OPERATIONS.OPRN_NO
, OPERATIONS.OPRN_VERS
, RECIPES.RECIPE_NO
, RECIPES.RECIPE_VERSION
, ROUTINGS.ROUTING_NO
, ROUTINGS.ROUTING_VERS
FROM GMD_SAMPLES GSMP
, FM_FORM_MST_B FORMULAMST
, GME_BATCH_HEADER BATCHHEADER
, GMD_OPERATIONS OPERATIONS
, GMD_RECIPES_B RECIPES
, GMD_ROUTINGS_B ROUTINGS
WHERE GSMP.BATCH_ID = BATCHHEADER.BATCH_ID(+)
AND GSMP.FORMULA_ID = FORMULAMST.FORMULA_ID(+)
AND GSMP.OPRN_ID = OPERATIONS.OPRN_ID(+)
AND GSMP.RECIPE_ID = RECIPES.RECIPE_ID(+)
AND GSMP.ROUTING_ID = ROUTINGS.ROUTING_ID(+)
AND GSMP.SOURCE = 'W'
Columns
Name |
SAMPLE_ID |
BATCH_NO |
ORGANIZATION_ID |
FORMULA_NO |
FORMULA_VERS |
OPRN_NO |
OPRN_VERS |
RECIPE_NO |
RECIPE_VERSION |
ROUTING_NO |
ROUTING_VERS |