APPS.WSH_ITM_EXPORT_SCREENING dependencies on WSH_DELIVERY_ASSIGNMENTS

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

446: ' AND WND.DELIVERY_ID = WE.DELIVERY_ID '||
447: ' AND WND.DELIVERY_ID = (SELECT '||
448: ' WDA.DELIVERY_ID '||
449: ' FROM '||
450: ' WSH_DELIVERY_ASSIGNMENTS WDA '||
451: ' WHERE '||
452: ' WDA.DELIVERY_ID = WND.DELIVERY_ID '||
453: ' AND ROWNUM = 1) ' ;
454: l_Delivery_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;