APPS.GMD_RECIPE_MIGRATION dependencies on IC_ITEM_MST

Line 46: ic_item_mst i

42: i.item_desc1
43: FROM fm_form_mst_b h,
44: fm_form_eff_bak e,
45: fm_matl_dtl m,
46: ic_item_mst i
47: WHERE NOT EXISTS ( SELECT 1
48: FROM gmd_recipe_eff_assoc
49: WHERE fmeff_id = e.fmeff_id )
50: AND e.formula_id = m.formula_id

Line 159: /* Check if the item id exists in ic_item_mst table */

155: SELECT recipe_validity_rule_id,
156: item_id
157: FROM gmd_recipe_validity_rules;
158:
159: /* Check if the item id exists in ic_item_mst table */
160: CURSOR get_valid_item ( v_item_id NUMBER )
161: IS
162: SELECT 1
163: FROM sys.DUAL

Line 165: FROM ic_item_mst

161: IS
162: SELECT 1
163: FROM sys.DUAL
164: WHERE EXISTS ( SELECT 1
165: FROM ic_item_mst
166: WHERE item_id = v_item_id
167: AND delete_mark = 0 );
168:
169: /* Get the costing details based on effectivities that have cost rollup done */