DBA Data[Home] [Help]

APPS.WSH_OTM_SYNC_ITEM_PKG dependencies on WSH_DELIVERY_DETAILS

Line 32: wsh_delivery_details wdd,

28: substrb(mtlt.description,1,120),
29: mtlb.last_update_date,
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

Line 56: wsh_delivery_details wdd,

52: substrb(mtlt.description,1,120),
53: mtlb.last_update_date,
54: mtlb.organization_id
55: FROM wsh_delivery_assignments wda,
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,