DBA Data[Home] [Help]

APPS.ISC_DBI_WSH_FTE_OBJECTS_C dependencies on WSH_DELIVERY_DETAILS

Line 317: FROM wsh_delivery_details wdd,

313: wdd.requested_quantity REQUESTED_QUANTITY,
314: wdd.requested_quantity_uom REQUESTED_QUANTITY_UOM,
315: wdd.shipped_quantity SHIPPED_QUANTITY,
316: mp.wms_enabled_flag WMS_ENABLED_FLAG
317: FROM wsh_delivery_details wdd,
318: wsh_delivery_assignments wda,
319: wsh_new_deliveries wnd,
320: mtl_txn_request_lines mol,
321: mtl_material_transactions mmt,

Line 686: WHERE NOT EXISTS (select '1' from wsh_delivery_details wdd

682:
683: DELETE FROM isc_dbi_del_details_f
684: WHERE delivery_detail_id IN (SELECT DISTINCT log.delivery_detail_id
685: FROM isc_dbi_tmp_wdd_log log
686: WHERE NOT EXISTS (select '1' from wsh_delivery_details wdd
687: where wdd.delivery_detail_id = log.delivery_detail_id
688: and wdd.released_status in ('S','Y','C','L','P')));
689:
690: FII_UTIL.Stop_Timer;

Line 731: wsh_delivery_details wdd,

727: wdd.requested_quantity_uom REQUESTED_QUANTITY_UOM,
728: wdd.shipped_quantity SHIPPED_QUANTITY,
729: mp.wms_enabled_flag WMS_ENABLED_FLAG
730: FROM (select distinct delivery_detail_id from isc_dbi_tmp_wdd_log) log,
731: wsh_delivery_details wdd,
732: wsh_delivery_assignments wda,
733: wsh_new_deliveries wnd,
734: mtl_txn_request_lines mol,
735: mtl_material_transactions mmt,