DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on GME_MATERIAL_DETAILS

Line 1562: , gme_material_details md

1558: SELECT gr.recipe_id, gr.recipe_no, gr.recipe_version
1559: , ffm.formula_id, ffm.formula_no, ffm.formula_vers
1560: , rout.routing_id, rout.routing_no, rout.routing_vers
1561: FROM gme_batch_header bh
1562: , gme_material_details md
1563: , gmd_recipes_b gr -- just need base table here not view
1564: , gmd_recipe_validity_rules rvr
1565: , gmd_status gs
1566: , fm_matl_dtl fmd

Line 1706: FROM gme_material_details

1702:
1703: -- Bug 4640143: added this cursor
1704: CURSOR c_material_detail_id IS
1705: SELECT 1
1706: FROM gme_material_details
1707: WHERE inventory_item_id = p_spec.inventory_item_id
1708: AND batch_id = l_wip_vr.batch_id
1709: AND organization_id = l_wip_vr.organization_id
1710: AND material_detail_id = l_wip_vr.material_detail_id;