APPS.GME_API_GRP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1141: FROM mtl_system_items_kfv

1137: CURSOR item_master_cursor (v_item_id NUMBER
1138: ,v_org_id NUMBER) IS
1139: SELECT concatenated_segments, mtl_transactions_enabled_flag, process_execution_enabled_flag,
1140: eng_item_flag, primary_uom_code, reservable_type
1141: FROM mtl_system_items_kfv
1142: WHERE inventory_item_id = v_item_id
1143: AND organization_id = v_org_id;
1144:
1145: CURSOR get_ingredients (

Line 1156: FROM gme_material_details m, gme_batch_header h, mtl_system_items_kfv i

1152: ) IS
1153: SELECT m.material_detail_id, m.batch_id, h.batch_no, m.material_requirement_date, m.line_no,
1154: m.formulaline_id, m.plan_qty, m.dtl_um, m.scale_multiple, h.formula_id,
1155: m.inventory_item_id, m.move_order_line_id, i.concatenated_segments item_no, h.organization_id, h.batch_type
1156: FROM gme_material_details m, gme_batch_header h, mtl_system_items_kfv i
1157: WHERE m.batch_id = h.batch_id
1158: AND h.organization_id = v_org_id
1159: AND h.batch_status = 1
1160: AND m.material_requirement_date >= v_start_date