APPS.GMD_SPEC_VRS_GRP dependencies on FM_FORM_MST

Line 1608: , fm_form_mst_b ffm -- just need base table here not view

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
1610: WHERE rout.routing_id(+) = bh.routing_id
1611: AND rvr.recipe_validity_rule_id = bh.recipe_validity_rule_id
1612: AND rvr.recipe_id = gr.recipe_id

Line 1653: , fm_form_mst ffm

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
1656: AND ffm.formula_id = r.formula_id
1657: AND rvr.recipe_id = r.recipe_id

Line 1680: , fm_form_mst ffm

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
1683: AND ffm.formula_id = r.formula_id
1684: AND rvr.recipe_id = r.recipe_id

Line 1705: , fm_form_mst ffm

1701:
1702: CURSOR c_formula_id IS
1703: SELECT ffm.formula_no, ffm.formula_vers
1704: FROM gmd_recipes grec
1705: , fm_form_mst ffm
1706: , fm_matl_dtl fmd
1707: , gem_lookups gl
1708: , gmd_status s
1709: WHERE s.status_code = ffm.formula_status

Line 1725: , fm_form_mst ffm

1721:
1722: CURSOR c_formula_no IS
1723: SELECT ffm.formula_id, ffm.formula_vers
1724: FROM gmd_recipes grec
1725: , fm_form_mst ffm
1726: , fm_matl_dtl fmd
1727: , gem_lookups gl
1728: , gmd_status s
1729: WHERE s.status_code = ffm.formula_status

Line 1830: , fm_form_mst ffm

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
1834: AND (NVL( l_wip_vr.organization_id, rvr.organization_id) = rvr.organization_id OR rvr.organization_id IS NULL)

Line 1851: , fm_form_mst ffm

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
1855: AND (NVL( l_wip_vr.organization_id, rvr.organization_id) = rvr.organization_id OR rvr.organization_id IS NULL)

Line 1880: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;

1876:
1877: l_recipe_id GMD_RECIPES.RECIPE_ID%TYPE;
1878: l_recipe_no GMD_RECIPES.RECIPE_NO%TYPE;
1879: l_recipe_version GMD_RECIPES.RECIPE_VERSION%TYPE;
1880: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;
1881: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
1882: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
1883: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;
1884: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;

Line 1881: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;

1877: l_recipe_id GMD_RECIPES.RECIPE_ID%TYPE;
1878: l_recipe_no GMD_RECIPES.RECIPE_NO%TYPE;
1879: l_recipe_version GMD_RECIPES.RECIPE_VERSION%TYPE;
1880: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;
1881: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
1882: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
1883: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;
1884: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
1885: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;

Line 1882: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;

1878: l_recipe_no GMD_RECIPES.RECIPE_NO%TYPE;
1879: l_recipe_version GMD_RECIPES.RECIPE_VERSION%TYPE;
1880: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;
1881: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
1882: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
1883: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;
1884: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
1885: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
1886: l_step_no GMD_WIP_SPEC_VRS.STEP_NO%TYPE;