eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SPEC_VRS_GRP dependencies on FM_MATL_DTL

Line 1607: , fm_matl_dtl fmd

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

Line 1654: , fm_matl_dtl fmd

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

Line 1681: , fm_matl_dtl fmd

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

Line 1706: , fm_matl_dtl fmd

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
1710: AND gl.lookup_code = fmd.line_type

Line 1726: , fm_matl_dtl fmd

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
1730: AND gl.lookup_code = fmd.line_type

Line 1746: FROM fm_matl_dtl fmd

1742:
1743:
1744: CURSOR c_formulaline_id IS
1745: SELECT 1
1746: FROM fm_matl_dtl fmd
1747: WHERE fmd.inventory_item_id = p_spec.inventory_item_id
1748: AND fmd.formula_id = l_wip_vr.formula_id
1749: AND fmd.formulaline_id = l_wip_vr.formulaline_id;
1750:

Line 1831: , fm_matl_dtl fmd

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)
1835: AND r.recipe_status = s.status_code

Line 1852: , fm_matl_dtl fmd

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)
1856: AND r.recipe_status = s.status_code