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 216: FROM WSH_DELIVERY_DETAILS wdd,wsh_delivery_assignments wda

212:
213: CURSOR c_get_delivery_details(c_delivery_id IN NUMBER)
214: IS
215: SELECT wdd.delivery_detail_id, wdd.transaction_temp_id, wdd.inventory_item_id
216: FROM WSH_DELIVERY_DETAILS wdd,wsh_delivery_assignments wda
217: WHERE wda.delivery_id = c_delivery_id
218: AND wda.delivery_detail_id = wdd.delivery_detail_id;
219:
220: --Bug 9265708 removed join with wsh_delivery_details

Line 220: --Bug 9265708 removed join with wsh_delivery_details

216: FROM WSH_DELIVERY_DETAILS wdd,wsh_delivery_assignments wda
217: WHERE wda.delivery_id = c_delivery_id
218: AND wda.delivery_detail_id = wdd.delivery_detail_id;
219:
220: --Bug 9265708 removed join with wsh_delivery_details
221: --Bug 12727459 : Added nvl condition on to_serial_number.
222: CURSOR c_get_serial_num_range(c_transaction_temp_id IN NUMBER, c_delivery_detail_id IN NUMBER)
223: IS
224: SELECT c_delivery_detail_id,c_transaction_temp_id,mt.fm_serial_number,

Line 234: FROM wsh_delivery_details wdd

230: --Bug 12727459 : Added nvl condition on to_serial_number.
231: CURSOR c_get_serial_number_from_wdd(c_delivery_detail_id IN NUMBER)
232: IS
233: SELECT wdd.delivery_detail_id,null,wdd.serial_number,nvl(wdd.to_serial_number,wdd.serial_number),shipped_quantity
234: FROM wsh_delivery_details wdd
235: WHERE wdd.delivery_detail_id = c_delivery_detail_id;
236:
237: l_module_name CONSTANT VARCHAR2(100) := G_PKG_NAME || '.' || 'POPULATE_SERIAL_NUMBERS';
238: