eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_LPN_SYNC_COMM_PKG dependencies on WSH_DELIVERY_DETAILS

Line 30: from wsh_delivery_details wddc,

26:
27: cursor l_unpack_csr (p_hw_time_stamp IN DATE) is
28: select wddc.lpn_id,
29: wddp.lpn_id old_parent_lpn_id
30: from wsh_delivery_details wddc,
31: wsh_delivery_details wddp,
32: wsh_delivery_assignments_v wda,
33: wsh_wms_sync_tmp wlst
34: where wlst.delivery_detail_id = wda.delivery_detail_id

Line 31: wsh_delivery_details wddp,

27: cursor l_unpack_csr (p_hw_time_stamp IN DATE) is
28: select wddc.lpn_id,
29: wddp.lpn_id old_parent_lpn_id
30: from wsh_delivery_details wddc,
31: wsh_delivery_details wddp,
32: wsh_delivery_assignments_v wda,
33: wsh_wms_sync_tmp wlst
34: where wlst.delivery_detail_id = wda.delivery_detail_id
35: and wddc.delivery_detail_id = wda.delivery_detail_id

Line 53: from wsh_delivery_details wddc,

49:
50: cursor l_pack_csr (p_hw_time_stamp IN DATE) is
51: select wddc.lpn_id,
52: wddp.lpn_id parent_lpn_id
53: from wsh_delivery_details wddc,
54: wsh_delivery_details wddp,
55: wsh_delivery_assignments_v wda,
56: wsh_wms_sync_tmp wlst
57: where wlst.delivery_detail_id = wda.delivery_detail_id

Line 54: wsh_delivery_details wddp,

50: cursor l_pack_csr (p_hw_time_stamp IN DATE) is
51: select wddc.lpn_id,
52: wddp.lpn_id parent_lpn_id
53: from wsh_delivery_details wddc,
54: wsh_delivery_details wddp,
55: wsh_delivery_assignments_v wda,
56: wsh_wms_sync_tmp wlst
57: where wlst.delivery_detail_id = wda.delivery_detail_id
58: and wddc.delivery_detail_id = wda.delivery_detail_id

Line 76: from wsh_delivery_details wdd,

72:
73: cursor l_unassign_csr (p_hw_time_stamp IN DATE) is
74: select wdd.lpn_id,
75: wlst.delivery_id old_delivery_id
76: from wsh_delivery_details wdd,
77: wsh_delivery_assignments_v wda,
78: wsh_wms_sync_tmp wlst
79: where wlst.delivery_detail_id = wda.delivery_detail_id
80: and wdd.delivery_detail_id = wda.delivery_detail_id

Line 97: from wsh_delivery_details wdd,

93:
94: cursor l_assign_csr (p_hw_time_stamp IN DATE) is
95: select wdd.lpn_id,
96: wda.delivery_id new_delivery_id
97: from wsh_delivery_details wdd,
98: wsh_delivery_assignments_v wda,
99: wsh_wms_sync_tmp wlst
100: where wlst.delivery_detail_id = wda.delivery_detail_id
101: and wdd.delivery_detail_id = wda.delivery_detail_id

Line 128: from wsh_delivery_details wdd,

124: wdd.filled_volume,
125: wdd.volume,
126: wdd.weight_uom_code,
127: wdd.net_weight
128: from wsh_delivery_details wdd,
129: wsh_wms_sync_tmp wlst
130: where wlst.delivery_detail_id = wdd.delivery_detail_id
131: and wdd.lpn_id is not null
132: and wlst.operation_type = 'UPDATE'

Line 556: from wsh_delivery_details wdd,

552: wdd.volume,
553: wdd.weight_uom_code,
554: wdd.net_weight,
555: wlst.call_level
556: from wsh_delivery_details wdd,
557: wsh_wms_sync_tmp wlst
558: where wlst.delivery_detail_id = wdd.delivery_detail_id
559: and wdd.lpn_id is not null
560: and wlst.operation_type = 'UPDATE'