APPS.WSH_ITM_EXPORT_SCREENING dependencies on WSH_DELIVERY_ASSIGNMENTS

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 437: ' WSH_DELIVERY_ASSIGNMENTS WDA '||

433: ' AND WND.DELIVERY_ID = WE.DELIVERY_ID '||
434: ' AND WND.DELIVERY_ID = (SELECT '||
435: ' WDA.DELIVERY_ID '||
436: ' FROM '||
437: ' WSH_DELIVERY_ASSIGNMENTS WDA '||
438: ' WHERE '||
439: ' WDA.DELIVERY_ID = WND.DELIVERY_ID '||
440: ' AND ROWNUM = 1) ' ;
441: l_Delivery_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;