APPS.GMD_VALIDITY_RULES_PVT dependencies on FM_MATL_DTL

Line 32: Select 1 from fm_matl_dtl fm

28: # HISTORY
29: #####################################################*/
30: FUNCTION Determine_Product(pRecipe_id NUMBER, pItem_id NUMBER) RETURN BOOLEAN IS
31: CURSOR product_cur(vRecipe_id NUMBER, vItem_id NUMBER) IS
32: Select 1 from fm_matl_dtl fm
33: Where exists (Select 1
34: From gmd_recipes_b rc
35: Where fm.formula_id = rc.formula_id
36: And fm.line_type IN (1,2)

Line 510: From fm_matl_dtl d, gmd_recipes_b r

506: ,vItem_id ic_item_mst_b.item_id%TYPE) IS
507: SELECT 1
508: FROM sys.dual
509: WHERE EXISTS (Select d.formula_id
510: From fm_matl_dtl d, gmd_recipes_b r
511: WHERE r.formula_id = d.formula_id AND
512: r.recipe_id = vRecipe_id AND
513: d.line_type = 1 AND
514: d.inventory_item_id = vItem_id AND -- NPD Conv.