APPS.MST_WB_UTIL dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1563: FROM mtl_system_items_kfv msikfv, fte_vehicle_types fvt

1559: fnd_message.set_token('ITEM_DESCRIPTION', l_temp1);
1560: -- vehicle_type
1561: SELECT msikfv.concatenated_segments
1562: into l_temp
1563: FROM mtl_system_items_kfv msikfv, fte_vehicle_types fvt
1564: WHERE fvt.vehicle_type_id = l_id2
1565: AND fvt.organization_id = msikfv.organization_id
1566: AND fvt.inventory_item_id = msikfv.inventory_item_id;
1567: fnd_message.set_token('VEHICLE_TYPE', l_temp);

Line 2168: FROM mtl_system_items_kfv msikfv,

2164: l_temp,
2165: msikfv.organization_id,
2166: msikfv.inventory_item_id)
2167: INTO l_id1
2168: FROM mtl_system_items_kfv msikfv,
2169: fte_vehicle_types fvt
2170: WHERE msikfv.inventory_item_id = fvt.inventory_item_id
2171: AND msikfv.organization_id = fvt.organization_id
2172: AND fvt.vehicle_type_id = l_id8;

Line 4447: FROM mtl_system_items_kfv msikfv,

4443: WHERE plan_id = P_PLAN_ID;
4444:
4445: CURSOR l_vehicle_cur (p_vehicle_type_id IN NUMBER) IS
4446: SELECT msikfv.concatenated_segments
4447: FROM mtl_system_items_kfv msikfv,
4448: fte_vehicle_types fvt
4449: WHERE fvt.vehicle_type_id = p_vehicle_type_id
4450: AND fvt.organization_id = msikfv.organization_id
4451: AND fvt.inventory_item_id = msikfv.inventory_item_id;

Line 5232: FROM mtl_system_items_kfv msikfv,

5228: l_str1,
5229: msikfv.organization_id,
5230: msikfv.inventory_item_id)
5231: INTO l_id9
5232: FROM mtl_system_items_kfv msikfv,
5233: fte_vehicle_types fvt
5234: WHERE msikfv.inventory_item_id = fvt.inventory_item_id
5235: AND msikfv.organization_id = fvt.organization_id
5236: AND fvt.vehicle_type_id = l_id8;

Line 5370: FROM mtl_system_items_kfv msikfv, fte_vehicle_types fvt

5366: fnd_message.set_token('ITEM_DESCRIPTION', l_str1);
5367:
5368: SELECT msikfv.concatenated_segments
5369: into l_str2
5370: FROM mtl_system_items_kfv msikfv, fte_vehicle_types fvt
5371: WHERE fvt.vehicle_type_id = l_id3
5372: AND fvt.organization_id = msikfv.organization_id
5373: AND fvt.inventory_item_id = msikfv.inventory_item_id;
5374: fnd_message.set_token('VEHICLE_TYPE', l_str2);