DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on GME_MATERIAL_DETAILS

Line 1727: , gme_material_details md

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

Line 1779: FROM gme_material_details

1775: -- Bug 4640143: added material_detail_id to samples
1776: CURSOR c_material_detail_id ( l_batch_id In NUMBER)
1777: IS
1778: SELECT 1
1779: FROM gme_material_details
1780: WHERE inventory_item_id = p_sample_rec.inventory_item_id
1781: AND organization_id = p_sample_rec.organization_id
1782: AND batch_id = l_batch_id
1783: AND material_detail_id = p_sample_rec.material_detail_id;