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.FTE_FREIGHT_PRICING dependencies on WSH_FREIGHT_COST_TYPES

Line 2589: FROM WSH_FREIGHT_COST_TYPES

2585: IS
2586:
2587: CURSOR c_get_fc_type_id IS
2588: SELECT freight_cost_type_id
2589: FROM WSH_FREIGHT_COST_TYPES
2590: WHERE freight_cost_type_code = p_line_type_code;
2591:
2592: CURSOR c_get_fc_charge_type_id IS
2593: SELECT freight_cost_type_id

Line 2594: FROM WSH_FREIGHT_COST_TYPES

2590: WHERE freight_cost_type_code = p_line_type_code;
2591:
2592: CURSOR c_get_fc_charge_type_id IS
2593: SELECT freight_cost_type_id
2594: FROM WSH_FREIGHT_COST_TYPES
2595: WHERE freight_cost_type_code = p_line_type_code
2596: AND name = p_charge_subtype_code;
2597:
2598: l_freight_cost_type_id NUMBER:=0;

Line 8356: FROM wsh_freight_cost_types wfct,

8352: x_return_status OUT NOCOPY VARCHAR2 )
8353: IS
8354: CURSOR c_get_services(c_delivery_detail_id IN NUMBER) IS
8355: SELECT DISTINCT wfct.freight_cost_type_code,wfct.freight_cost_type_id
8356: FROM wsh_freight_cost_types wfct,
8357: wsh_freight_costs wfc
8358: WHERE wfc.delivery_detail_id = c_delivery_detail_id
8359: AND wfc.charge_source_code = 'REQUESTED'
8360: AND wfc.freight_cost_type_id = wfct.freight_cost_type_id;