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.GR_EXPLOSIONS dependencies on FM_MATL_DTL

Line 149: fm_matl_dtl dtl

145: FROM fm_form_mst_b mst,
146: gmd_recipe_validity_rules rvr,
147: gmd_status_b sts,
148: gmd_recipes_b rcp,
149: fm_matl_dtl dtl
150: WHERE rvr.validity_rule_status = sts.status_code
151: AND sts.status_type in ('400','700','900')
152: AND rvr.recipe_id = rcp.recipe_id
153: AND mst.formula_id = rcp.formula_id

Line 183: fm_matl_dtl dtl

179: mtl.concatenated_segments item_no,
180: dtl.SCALE_ROUNDING_VARIANCE precision,
181: dtl.contribute_yield_ind
182: FROM mtl_system_items_kfv mtl,
183: fm_matl_dtl dtl
184: WHERE dtl.formula_id = EffectiveFormulaRecord.formula_id
185: AND dtl.line_type = -1
186: --AND dtl.organization_id = mtl.organization_id - Bug 5229785 do not join with detail organization since
187: AND mtl.organization_id = l_organization_id

Line 1049: fm_matl_dtl dtl,

1045: FROM fm_form_mst_b mst,
1046: gmd_recipe_validity_rules rvr,
1047: gmd_status_b sts,
1048: gmd_recipes_b rcp,
1049: fm_matl_dtl dtl,
1050: mtl_system_items mtl
1051: WHERE rvr.inventory_item_id = mtl.inventory_item_id
1052: AND rvr.validity_rule_status = sts.status_code
1053: AND sts.status_type in ('400','700','900')