DBA Data[Home] [Help]

APPS.GR_EXPLOSIONS dependencies on MTL_SYSTEM_ITEMS

Line 182: FROM mtl_system_items_kfv mtl,

178: dtl.detail_uom item_um,
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

Line 1050: mtl_system_items mtl

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')
1054: AND rvr.recipe_id = rcp.recipe_id