DBA Data[Home] [Help]

APPS.WSH_OTM_SYNC_ITEM_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 35: mtl_system_items_kfv mtlk

31: FROM wsh_delivery_assignments wda,
32: wsh_delivery_details wdd,
33: mtl_system_items_b mtlb,
34: mtl_system_items_tl mtlt,
35: mtl_system_items_kfv mtlk
36: WHERE wda.delivery_id = p_delivery_id
37: AND wda.delivery_detail_id = wdd.delivery_detail_id
38: AND wdd.inventory_item_id = mtlb.inventory_item_id
39: AND wdd.inventory_item_id = mtlt.inventory_item_id

Line 61: mtl_system_items_kfv mtlk

57: wsh_delivery_legs wdl,
58: wsh_trip_stops wts,
59: mtl_system_items_b mtlb,
60: mtl_system_items_tl mtlt,
61: mtl_system_items_kfv mtlk
62: WHERE wts.trip_id = p_trip_id
63: AND wts.stop_id = wdl.pick_up_stop_id
64: AND wda.delivery_id = wdl.delivery_id
65: AND wda.delivery_detail_id = wdd.delivery_detail_id