APPS.GMD_VALIDITY_RULES dependencies on MTL_SYSTEM_ITEMS_KFV

Line 124: mtl_system_items_kfv I, fm_matl_dtl d

120: /* Cursor to get data based on item. */
121: CURSOR get_val_item(l_quantity NUMBER) IS
122: SELECT v.*
123: FROM gmd_recipe_validity_rules v, gmd_recipes_b r, gmd_status_b s,
124: mtl_system_items_kfv I, fm_matl_dtl d
125: WHERE v.recipe_id = r.recipe_id
126: AND v.validity_rule_status = s.status_code
127: AND i.inventory_item_id = v.inventory_item_id
128: AND r.owner_organization_id = i.organization_id

Line 162: FROM mtl_system_items_kfv

158: l_item_id NUMBER;
159:
160: CURSOR get_item_id(p_item_no VARCHAR2) IS
161: SELECT inventory_item_id
162: FROM mtl_system_items_kfv
163: WHERE concatenated_segments = p_item_no;
164:
165: -- NPD Conv.
166: CURSOR cur_item_uom(p_item_id NUMBER) IS

Line 1210: FROM mtl_system_items_kfv

1206:
1207: -- NPD Conv. Modified cursor to get concatenated segments for the item_id
1208: CURSOR Cur_get_item IS
1209: SELECT concatenated_segments
1210: FROM mtl_system_items_kfv
1211: WHERE inventory_item_id = p_item_id;
1212: X_item_no VARCHAR2(32);
1213: BEGIN
1214: OPEN Cur_get_item;