DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on GME_MATERIAL_DETAILS

Line 1816: , gme_material_details md

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
1820: , fm_matl_dtl fmd

Line 1892: FROM gme_material_details

1888: -- Bug 4640143: added material_detail_id to samples
1889: CURSOR c_material_detail_id ( l_batch_id In NUMBER)
1890: IS
1891: SELECT 1
1892: FROM gme_material_details
1893: WHERE inventory_item_id = p_sample_rec.inventory_item_id
1894: AND organization_id = p_sample_rec.organization_id
1895: AND batch_id = l_batch_id
1896: AND material_detail_id = p_sample_rec.material_detail_id;