APPS.GME_API_GRP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1112: FROM mtl_system_items_kfv

1108: CURSOR item_master_cursor (v_item_id NUMBER
1109: ,v_org_id NUMBER) IS
1110: SELECT concatenated_segments, mtl_transactions_enabled_flag, process_execution_enabled_flag,
1111: eng_item_flag, primary_uom_code, reservable_type
1112: FROM mtl_system_items_kfv
1113: WHERE inventory_item_id = v_item_id
1114: AND organization_id = v_org_id;
1115:
1116: CURSOR get_ingredients (

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

1123: ) IS
1124: SELECT m.material_detail_id, m.batch_id, h.batch_no, m.material_requirement_date, m.line_no,
1125: m.formulaline_id, m.plan_qty, m.dtl_um, m.scale_multiple, h.formula_id,
1126: m.inventory_item_id, m.move_order_line_id, i.concatenated_segments item_no, h.organization_id, h.batch_type
1127: FROM gme_material_details m, gme_batch_header h, mtl_system_items_kfv i
1128: WHERE m.batch_id = h.batch_id
1129: AND h.organization_id = v_org_id
1130: AND h.batch_status = 1
1131: AND m.material_requirement_date >= v_start_date