VIEW: APPS.GMD_QC_E_WIP_SMPEVT_DTLS_V

Source

View Text - Preformatted

SELECT gsmpevt.sampling_event_id sampling_event_id, batchheader.batch_no ,params.organization_code, 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_sampling_events gsmpevt ,fm_form_mst_b formulamst ,gme_batch_header batchheader ,gmd_operations operations ,gmd_recipes_b recipes ,gmd_routings_b routings ,mtl_parameters params WHERE gsmpevt.batch_id = batchheader.batch_id(+) AND gsmpevt.formula_id = formulamst.formula_id(+) AND gsmpevt.oprn_id = operations.oprn_id(+) AND gsmpevt.recipe_id = recipes.recipe_id(+) AND gsmpevt.routing_id = routings.routing_id(+) AND gsmpevt.SOURCE = 'W' AND batchheader.organization_id = params.organization_id

View Text - HTML Formatted

SELECT GSMPEVT.SAMPLING_EVENT_ID SAMPLING_EVENT_ID
, BATCHHEADER.BATCH_NO
, PARAMS.ORGANIZATION_CODE
, 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_SAMPLING_EVENTS GSMPEVT
, FM_FORM_MST_B FORMULAMST
, GME_BATCH_HEADER BATCHHEADER
, GMD_OPERATIONS OPERATIONS
, GMD_RECIPES_B RECIPES
, GMD_ROUTINGS_B ROUTINGS
, MTL_PARAMETERS PARAMS
WHERE GSMPEVT.BATCH_ID = BATCHHEADER.BATCH_ID(+)
AND GSMPEVT.FORMULA_ID = FORMULAMST.FORMULA_ID(+)
AND GSMPEVT.OPRN_ID = OPERATIONS.OPRN_ID(+)
AND GSMPEVT.RECIPE_ID = RECIPES.RECIPE_ID(+)
AND GSMPEVT.ROUTING_ID = ROUTINGS.ROUTING_ID(+)
AND GSMPEVT.SOURCE = 'W'
AND BATCHHEADER.ORGANIZATION_ID = PARAMS.ORGANIZATION_ID