APPS.GMD_SPEC_VRS_GRP dependencies on GMD_RECIPE_VALIDITY_RULES

Line 1605: , gmd_recipe_validity_rules rvr

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
1608: , fm_form_mst_b ffm -- just need base table here not view
1609: , gmd_routings_b rout -- just need base table here not view

Line 1651: , gmd_recipe_validity_rules rvr

1647: , ffm.formula_id, ffm.formula_no, ffm.formula_vers
1648: , rout.routing_id, rout.routing_no, rout.routing_vers
1649: FROM gmd_recipes r
1650: , gmd_status s
1651: , gmd_recipe_validity_rules rvr
1652: , gmd_routings rout
1653: , fm_form_mst ffm
1654: , fm_matl_dtl fmd
1655: WHERE rout.routing_id(+) = r.routing_id

Line 1678: , gmd_recipe_validity_rules rvr

1674: CURSOR c_recipe_no IS
1675: SELECT r.recipe_id, r.recipe_version
1676: FROM gmd_recipes r
1677: , gmd_status s
1678: , gmd_recipe_validity_rules rvr
1679: , gmd_routings rout
1680: , fm_form_mst ffm
1681: , fm_matl_dtl fmd
1682: WHERE rout.routing_id(+) = r.routing_id

Line 1829: , gmd_recipe_validity_rules rvr

1825: SELECT r.recipe_no, r.recipe_version
1826: , ffm.formula_id, ffm.formula_no, ffm.formula_vers
1827: FROM gmd_recipes r
1828: , gmd_status s
1829: , gmd_recipe_validity_rules rvr
1830: , fm_form_mst ffm
1831: , fm_matl_dtl fmd
1832: WHERE ffm.formula_id = r.formula_id
1833: AND rvr.recipe_id = r.recipe_id

Line 1850: , gmd_recipe_validity_rules rvr

1846: CURSOR c_recipe_no_no_route IS
1847: SELECT r.recipe_id, r.recipe_version
1848: FROM gmd_recipes r
1849: , gmd_status s
1850: , gmd_recipe_validity_rules rvr
1851: , fm_form_mst ffm
1852: , fm_matl_dtl fmd
1853: WHERE ffm.formula_id = r.formula_id
1854: AND rvr.recipe_id = r.recipe_id