APPS.WMS_DIRECT_SHIP_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 224: ,mtl_system_items_kfv msi

220: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wt.ship_method_code)
221: ,wt.ship_method_code
222: FROM wsh_trips_ob_grp_v wt
223: ,wsh_trip_stops_ob_grp_v wts
224: ,mtl_system_items_kfv msi
225: WHERE wt.trip_id = p_trip_id
226: AND wt.trip_id = wts.trip_id
227: AND (wt.vehicle_item_id = msi.inventory_item_id(+)
228: AND msi.organization_id(+) = p_org_id)

Line 1138: ,mtl_system_items_kfv msik

1134: msik.description
1135: from wsh_delivery_details_ob_grp_v wdd
1136: ,wsh_delivery_assignments_v wda
1137: ,wsh_new_deliveries_ob_grp_v wnd
1138: ,mtl_system_items_kfv msik
1139: where wnd.delivery_id = p_delivery_id
1140: AND wnd.delivery_id = wda.delivery_id
1141: AND wda.delivery_detail_id = wdd.delivery_detail_id
1142: AND wdd.lpn_id is null

Line 9005: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, mtl_system_items_kfv msik

9001: x_return_status := fnd_api.g_ret_sts_success;
9002:
9003: SELECT COUNT(*)
9004: INTO l_count
9005: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, mtl_system_items_kfv msik
9006: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
9007: AND NVL(wdd.container_flag, 'N') = 'N'
9008: AND wda.delivery_id = p_delivery_id
9009: AND wdd.inventory_item_id = msik.inventory_item_id

Line 12487: FROM wms_direct_ship_temp wds, oe_order_lines_all oel, mtl_system_items_kfv msi

12483: , oel.end_item_unit_number
12484: , oel.request_date
12485: , msi.primary_uom_code
12486: , msi.secondary_uom_code
12487: FROM wms_direct_ship_temp wds, oe_order_lines_all oel, mtl_system_items_kfv msi
12488: WHERE wds.organization_id = p_org_id
12489: AND wds.GROUP_ID = g_group_id
12490: AND wds.dock_door_id = p_dock_door_id
12491: AND wds.lpn_id = p_lpn_id