DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on GME_BATCH_HEADER

Line 247: FROM gme_batch_header

243: */
244:
245: CURSOR Cur_batch_status IS -- Bug # 4619570 Need to know if batch is closed
246: SELECT batch_status
247: FROM gme_batch_header
248: WHERE batch_id = l_qc_samples_out_rec.batch_id;
249:
250: -- pal 5283854
251: CURSOR c_get_lot_optional (p_spec_vr_id NUMBER)

Line 1726: FROM gme_batch_header bh

1722: IS
1723: SELECT DISTINCT gr.recipe_id,
1724: ffm.formula_id,
1725: rout.routing_id
1726: FROM gme_batch_header bh
1727: , gme_material_details md
1728: , gmd_recipes_b gr/*gmd_recipes gr bug#4916871*/
1729: , gmd_recipe_validity_rules rvr
1730: , gmd_status gs