DBA Data[Home] [Help]

APPS.ISC_DBI_WSH_FTE_OBJECTS_C dependencies on WSH_FREIGHT_COSTS

Line 451: from wsh_freight_costs wfc,wsh_freight_cost_types wfct,

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,
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

Line 934: from wsh_freight_costs wfc,wsh_freight_cost_types wfct,

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,
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