APPS.WMS_DIRECT_SHIP_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 183: ,mtl_system_items_kfv msi

179: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wt.ship_method_code)
180: ,wt.ship_method_code
181: FROM wsh_trips_ob_grp_v wt
182: ,wsh_trip_stops_ob_grp_v wts
183: ,mtl_system_items_kfv msi
184: WHERE wt.trip_id = p_trip_id
185: AND wt.trip_id = wts.trip_id
186: AND (wt.vehicle_item_id = msi.inventory_item_id(+)
187: AND msi.organization_id(+) = p_org_id)

Line 1055: ,mtl_system_items_kfv msik

1051: msik.description
1052: from wsh_delivery_details_ob_grp_v wdd
1053: ,wsh_delivery_assignments_v wda
1054: ,wsh_new_deliveries_ob_grp_v wnd
1055: ,mtl_system_items_kfv msik
1056: where wnd.delivery_id = p_delivery_id
1057: AND wnd.delivery_id = wda.delivery_id
1058: AND wda.delivery_detail_id = wdd.delivery_detail_id
1059: AND wdd.lpn_id is null

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

7904: x_return_status := fnd_api.g_ret_sts_success;
7905:
7906: SELECT COUNT(*)
7907: INTO l_count
7908: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, mtl_system_items_kfv msik
7909: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
7910: AND NVL(wdd.container_flag, 'N') = 'N'
7911: AND wda.delivery_id = p_delivery_id
7912: AND wdd.inventory_item_id = msik.inventory_item_id

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

10697: , oel.item_revision revision
10698: , oel.end_item_unit_number
10699: , oel.request_date
10700: , msi.primary_uom_code
10701: FROM wms_direct_ship_temp wds, oe_order_lines_all oel, mtl_system_items_kfv msi
10702: WHERE wds.organization_id = p_org_id
10703: AND wds.GROUP_ID = g_group_id
10704: AND wds.dock_door_id = p_dock_door_id
10705: AND wds.lpn_id = p_lpn_id