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.WMS_SHIPPING_PUB dependencies on WSH_DELIVERY_DETAILS

Line 100: FROM wsh_delivery_details

96: IF l_organization_id IS NULL THEN
97: -- Assuming that all deliveries being ship confirmed belong to the same org
98: SELECT organization_id
99: INTO l_organization_id
100: FROM wsh_delivery_details
101: WHERE delivery_detail_id = l_delivery_detail_id;
102: END IF;
103: IF l_debug = 1 THEN debug('Deleting mtl_material_transactions_temp '); END IF;
104:

Line 116: wsh_delivery_details wdd,

112: AND organization_id = l_organization_id
113: AND transfer_lpn_id IN
114: (SELECT wlpn.outermost_lpn_id
115: FROM wms_license_plate_numbers wlpn,
116: wsh_delivery_details wdd,
117: wsh_delivery_assignments_v wda
118: WHERE wda.delivery_detail_id = l_delivery_detail_id
119: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
120: AND wdd.lpn_id = wlpn.lpn_id);

Line 134: wsh_delivery_details wdd,

130: AND organization_id = l_organization_id
131: AND content_lpn_id IN
132: ( SELECT wlpn.outermost_lpn_id
133: FROM wms_license_plate_numbers wlpn,
134: wsh_delivery_details wdd,
135: wsh_delivery_assignments_v wda
136: WHERE wda.delivery_detail_id = l_delivery_detail_id
137: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
138: AND wdd.lpn_id = wlpn.lpn_id);