DBA Data[Home] [Help]

APPS.WSH_OTM_SYNC_ITEM_PKG dependencies on MTL_SYSTEM_ITEMS_TL

Line 34: mtl_system_items_tl mtlt,

30: mtlb.organization_id
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

Line 60: mtl_system_items_tl mtlt,

56: wsh_delivery_details wdd,
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