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_ITM_EXPORT_SCREENING dependencies on WSH_DELIVERY_DETAILS

Line 205: FROM WSH_DELIVERY_DETAILS wdd,wsh_delivery_assignments wda

201:
202: CURSOR c_get_delivery_details(c_delivery_id IN NUMBER)
203: IS
204: SELECT wdd.delivery_detail_id, wdd.transaction_temp_id, wdd.inventory_item_id
205: FROM WSH_DELIVERY_DETAILS wdd,wsh_delivery_assignments wda
206: WHERE wda.delivery_id = c_delivery_id
207: AND wda.delivery_detail_id = wdd.delivery_detail_id;
208:
209: CURSOR c_get_serial_num_range(c_transaction_temp_id IN NUMBER, c_delivery_detail_id IN NUMBER)

Line 213: FROM mtl_serial_numbers_temp mt , wsh_delivery_details wdd

209: CURSOR c_get_serial_num_range(c_transaction_temp_id IN NUMBER, c_delivery_detail_id IN NUMBER)
210: IS
211: SELECT wdd.delivery_detail_id,wdd.transaction_temp_id,mt.fm_serial_number,
212: mt.to_serial_number , to_number(mt.serial_prefix) quantity
213: FROM mtl_serial_numbers_temp mt , wsh_delivery_details wdd
214: WHERE mt.transaction_temp_id = c_transaction_temp_id
215: AND wdd.transaction_temp_id = mt.transaction_temp_id
216: AND wdd.delivery_detail_id = c_delivery_detail_id;
217:

Line 221: FROM wsh_delivery_details wdd

217:
218: CURSOR c_get_serial_number_from_wdd(c_delivery_detail_id IN NUMBER)
219: IS
220: SELECT wdd.delivery_detail_id,null,wdd.serial_number,wdd.to_serial_number,shipped_quantity
221: FROM wsh_delivery_details wdd
222: WHERE wdd.delivery_detail_id = c_delivery_detail_id;
223:
224: l_module_name CONSTANT VARCHAR2(100) := G_PKG_NAME || '.' || 'POPULATE_SERIAL_NUMBERS';
225: