APPS.WSH_TMS_RELEASE dependencies on WSH_FREIGHT_COSTS_INTERFACE

Line 973: FROM wsh_freight_costs_interface

969: uom,
970: total_amount,
971: currency_code,
972: delivery_id
973: FROM wsh_freight_costs_interface
974: WHERE delivery_id = p_delivery_id
975: AND interface_action_code = G_TMS_RELEASE_CODE;
976:
977: CURSOR c_get_currency_code(p_trip_interface_id IN NUMBER) IS

Line 1005: wsh_freight_costs_interface wfci,

1001: wfci.freight_cost_interface_id
1002: from wsh_trips_interface wti ,
1003: wsh_trip_stops_interface wtsi ,
1004: wsh_del_legs_interface wdli ,
1005: wsh_freight_costs_interface wfci,
1006: wsh_new_del_interface wndi
1007: where wti.trip_interface_id = c_trip_interface_id --Bug7717569
1008: and wdli.delivery_interface_id = wndi.delivery_interface_id
1009: and wndi.delivery_interface_id = wfci.delivery_interface_id (+)

Line 3133: -- Delivery id in wsh_freight_costs_interface would be populated

3129: WSH_DEBUG_SV.logmsg(l_module_name,'===============================');
3130: END IF;
3131:
3132: DECLARE
3133: -- Delivery id in wsh_freight_costs_interface would be populated
3134: -- while importing information from Glog
3135:
3136: -- variables
3137: l_freight_info_tab WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;

Line 4171: -- Purge records in wsh_freight_costs_interface

4167: --=========================================================================
4168: -- Procedure: PURGE_INTERFACE_DATA
4169: -- Description:
4170: -- wsh_del_details_interface and wsh_del_assgn_interface will not be populated
4171: -- Purge records in wsh_freight_costs_interface
4172: -- If p_exception_action =PURGE, then purge the exceptions
4173: -- for WSH_OTM_SHIPMENT_ERROR
4174: -- elsif p_exception_action = CLOSE, then close the exception
4175: -- for WSH_OTM_SHIPMENT_ERROR(used for reprocessing from Interface Mesg

Line 4259: Delete from wsh_freight_costs_interface wfci

4255: END IF;
4256:
4257: -- Purge wsh_freight_cost_interface
4258: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4259: Delete from wsh_freight_costs_interface wfci
4260: where wfci.delivery_interface_id in (
4261: select wdli.delivery_interface_id
4262: from wsh_trip_stops_interface wtsi,
4263: wsh_del_legs_interface wdli