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 161: FROM mtl_system_items_kfv

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

Line 1188: FROM mtl_system_items_kfv

1184:
1185: -- NPD Conv. Modified cursor to get concatenated segments for the item_id
1186: CURSOR Cur_get_item IS
1187: SELECT concatenated_segments
1188: FROM mtl_system_items_kfv
1189: WHERE inventory_item_id = p_item_id;
1190: X_item_no VARCHAR2(32);
1191: BEGIN
1192: OPEN Cur_get_item;