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 513: From fm_matl_dtl d, gmd_recipes_b r

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