eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SAMPLES_PUB dependencies on GME_BATCH_HEADER

Line 257: FROM gme_batch_header

253: */
254:
255: CURSOR Cur_batch_status IS -- Bug # 4619570 Need to know if batch is closed
256: SELECT batch_status
257: FROM gme_batch_header
258: WHERE batch_id = l_qc_samples_out_rec.batch_id;
259:
260: -- 5283854
261: CURSOR c_get_lot_optional (p_spec_vr_id NUMBER)

Line 1815: FROM gme_batch_header bh

1811: IS
1812: SELECT DISTINCT gr.recipe_id,
1813: ffm.formula_id,
1814: rout.routing_id
1815: FROM gme_batch_header bh
1816: , gme_material_details md
1817: , gmd_recipes_b gr/*gmd_recipes gr bug#4916871*/
1818: , gmd_recipe_validity_rules rvr
1819: , gmd_status gs

Line 1864: , gme_batch_header gbh

1860: , gr.formula_id
1861: , gr.routing_id
1862: FROM gmd_recipes_b gr
1863: , gmd_recipe_validity_rules grvr
1864: , gme_batch_header gbh
1865: WHERE gbh.batch_id = p_sample_rec.batch_id
1866: AND grvr.recipe_validity_rule_id = gbh.recipe_validity_rule_id
1867: AND gr.recipe_id = grvr.recipe_id
1868: AND gbh.batch_type = 0