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.ISC_DBI_WSH_FTE_OBJECTS_C dependencies on WSH_NEW_DELIVERIES

Line 319: wsh_new_deliveries wnd,

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,
322: mtl_parameters mp
323: WHERE wdd.released_status in ('S','Y','C','L','P')

Line 447: FROM wsh_new_deliveries wnd,

443: wnd.weight_uom_code WEIGHT_UOM_CODE,
444: gsb.currency_code WH_CURRENCY_CODE,
445: wnd.delivery_type DELIVERY_TYPE,
446: wdl.parent_delivery_leg_id PARENT_DELIVERY_LEG_ID
447: FROM wsh_new_deliveries wnd,
448: wsh_delivery_legs wdl,
449: (select /*+ PARALLEL(wfc) */
450: wfc.delivery_leg_id, total_amount, wfc.currency_code, conversion_type_code, conversion_rate, conversion_date
451: from wsh_freight_costs wfc,wsh_freight_cost_types wfct,

Line 452: wsh_new_deliveries wnd, wsh_delivery_legs wdl

448: wsh_delivery_legs wdl,
449: (select /*+ PARALLEL(wfc) */
450: wfc.delivery_leg_id, total_amount, wfc.currency_code, conversion_type_code, conversion_rate, conversion_date
451: from wsh_freight_costs wfc,wsh_freight_cost_types wfct,
452: wsh_new_deliveries wnd, wsh_delivery_legs wdl
453: where wfc.delivery_detail_id IS NULL
454: AND wfc.freight_cost_type_id = wfct.freight_cost_type_id
455: AND wnd.delivery_id = wdl.delivery_id
456: AND wdl.delivery_leg_id = wfc.delivery_leg_id

Line 733: wsh_new_deliveries wnd,

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,
736: mtl_parameters mp
737: WHERE wdd.delivery_detail_id = log.delivery_detail_id

Line 930: FROM wsh_new_deliveries wnd,

926: wnd.weight_uom_code WEIGHT_UOM_CODE,
927: gsb.currency_code WH_CURRENCY_CODE,
928: wnd.delivery_type DELIVERY_TYPE,
929: wdl.parent_delivery_leg_id PARENT_DELIVERY_LEG_ID
930: FROM wsh_new_deliveries wnd,
931: wsh_delivery_legs wdl,
932: (select /*+ use_nl (wfct, wfc) */
933: wfc.delivery_leg_id, total_amount, wfc.currency_code, conversion_type_code, conversion_rate, conversion_date
934: from wsh_freight_costs wfc,wsh_freight_cost_types wfct,

Line 935: wsh_new_deliveries wnd, wsh_delivery_legs wdl

931: wsh_delivery_legs wdl,
932: (select /*+ use_nl (wfct, wfc) */
933: wfc.delivery_leg_id, total_amount, wfc.currency_code, conversion_type_code, conversion_rate, conversion_date
934: from wsh_freight_costs wfc,wsh_freight_cost_types wfct,
935: wsh_new_deliveries wnd, wsh_delivery_legs wdl
936: where wfc.delivery_detail_id IS NULL
937: AND wfc.freight_cost_type_id = wfct.freight_cost_type_id
938: AND wnd.delivery_id = wdl.delivery_id
939: AND wdl.delivery_leg_id = wfc.delivery_leg_id

Line 1752: FROM wsh_new_deliveries

1748: WHERE conversion_rate between -99999 and -99995;
1749:
1750: CURSOR Missing_Transaction_UOM IS
1751: SELECT name
1752: FROM wsh_new_deliveries
1753: WHERE delivery_id IN (SELECT distinct delivery_id
1754: FROM isc_dbi_tmp_del_legs
1755: WHERE (freight_weight_trx is not null and weight_uom_code is null)
1756: OR (freight_volume_trx is not null and volume_uom_code is null));