DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on GME_MATERIAL_DETAILS

Line 1603: , gme_material_details md

1599: SELECT gr.recipe_id, gr.recipe_no, gr.recipe_version
1600: , ffm.formula_id, ffm.formula_no, ffm.formula_vers
1601: , rout.routing_id, rout.routing_no, rout.routing_vers
1602: FROM gme_batch_header bh
1603: , gme_material_details md
1604: , gmd_recipes_b gr -- just need base table here not view
1605: , gmd_recipe_validity_rules rvr
1606: , gmd_status gs
1607: , fm_matl_dtl fmd

Line 1755: FROM gme_material_details

1751:
1752: -- Bug 4640143: added this cursor
1753: CURSOR c_material_detail_id IS
1754: SELECT 1
1755: FROM gme_material_details
1756: WHERE inventory_item_id = p_spec.inventory_item_id
1757: AND batch_id = l_wip_vr.batch_id
1758: AND organization_id = l_wip_vr.organization_id
1759: AND material_detail_id = l_wip_vr.material_detail_id;