APPS.FTE_TL_RATING dependencies on FTE_FREIGHT_COSTS_TEMP

Line 773: FROM FTE_FREIGHT_COSTS_TEMP fct

769: c_schedule_id IN NUMBER,
770: c_vehicle_type_id IN NUMBER,
771: c_request_id IN NUMBER) IS
772: SELECT *
773: FROM FTE_FREIGHT_COSTS_TEMP fct
774: WHERE ( fct.comparison_request_id = c_request_id)
775: AND ((fct.lane_id = c_lane_id) OR (fct.schedule_id= c_schedule_id))
776: AND (fct.vehicle_type_id = c_vehicle_type_id)
777: AND(fct.CHARGE_SOURCE_CODE='PRICING_ENGINE')

Line 781: l_temp_rec FTE_FREIGHT_COSTS_TEMP%ROWTYPE;

777: AND(fct.CHARGE_SOURCE_CODE='PRICING_ENGINE')
778: FOR UPDATE NOWAIT;
779:
780:
781: l_temp_rec FTE_FREIGHT_COSTS_TEMP%ROWTYPE;
782: l_empty_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
783: l_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
784: l_freight_cost_id NUMBER;
785: l_return_status VARCHAR2(1);

Line 968: FROM FTE_FREIGHT_COSTS_TEMP fct

964: ---Delete fc temp record
965: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'>>7');
966:
967: DELETE
968: FROM FTE_FREIGHT_COSTS_TEMP fct
969: WHERE ( fct.comparison_request_id = p_comparison_request_id)
970: AND ((fct.lane_id = p_lane_id) OR (fct.schedule_id= p_schedule_id))
971: AND(fct.CHARGE_SOURCE_CODE='PRICING_ENGINE');
972:

Line 1048: FROM FTE_FREIGHT_COSTS_TEMP fct

1044: c_vehicle_type_id IN NUMBER,
1045: c_request_id IN NUMBER,
1046: c_fake_trip_id IN NUMBER) IS
1047: SELECT fct.trip_id
1048: FROM FTE_FREIGHT_COSTS_TEMP fct
1049: WHERE ( fct.comparison_request_id = c_request_id)
1050: AND ((fct.lane_id = c_lane_id) OR (fct.schedule_id= c_schedule_id))
1051: AND (fct.vehicle_type_id = c_vehicle_type_id)
1052: AND(fct.CHARGE_SOURCE_CODE='PRICING_ENGINE')

Line 1075: FROM FTE_FREIGHT_COSTS_TEMP fct

1071: c_schedule_id IN NUMBER,
1072: c_vehicle_type_id IN NUMBER,
1073: c_request_id IN NUMBER) IS
1074: SELECT *
1075: FROM FTE_FREIGHT_COSTS_TEMP fct
1076: WHERE ( fct.comparison_request_id = c_request_id)
1077: AND ((fct.lane_id = c_lane_id) OR (fct.schedule_id= c_schedule_id))
1078: AND (fct.vehicle_type_id = c_vehicle_type_id)
1079: AND(fct.CHARGE_SOURCE_CODE='PRICING_ENGINE')

Line 1083: l_temp_rec FTE_FREIGHT_COSTS_TEMP%ROWTYPE;

1079: AND(fct.CHARGE_SOURCE_CODE='PRICING_ENGINE')
1080: FOR UPDATE NOWAIT;
1081:
1082:
1083: l_temp_rec FTE_FREIGHT_COSTS_TEMP%ROWTYPE;
1084: l_empty_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
1085: l_freight_rec WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
1086: l_freight_cost_id NUMBER;
1087: l_return_status VARCHAR2(1);

Line 1336: FROM FTE_FREIGHT_COSTS_TEMP fct

1332: ---Delete fc temp record
1333: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'>>7');
1334:
1335: DELETE
1336: FROM FTE_FREIGHT_COSTS_TEMP fct
1337: WHERE ( fct.comparison_request_id = p_comparison_request_id)
1338: AND ((fct.lane_id = p_lane_id) OR (fct.schedule_id= p_schedule_id))
1339: AND(fct.CHARGE_SOURCE_CODE='PRICING_ENGINE');
1340:

Line 3433: FROM fte_freight_costs_temp ffct, wsh_freight_cost_types wfct

3429: CURSOR c_trip_sum(c_trip_id NUMBER, c_request_id NUMBER,
3430: c_lane_id NUMBER, c_schedule_id NUMBER)
3431: IS
3432: SELECT ffct.total_amount, ffct.currency_code
3433: FROM fte_freight_costs_temp ffct, wsh_freight_cost_types wfct
3434: WHERE ffct.freight_cost_type_id = wfct.freight_cost_type_id
3435: AND wfct.name='SUMMARY'
3436: AND ffct.trip_id = c_trip_id
3437: AND ffct.comparison_request_id = c_request_id

Line 3761: FROM fte_freight_costs_temp ffct, wsh_freight_cost_types wfct

3757: CURSOR c_trip_sum(c_trip_id NUMBER, c_request_id NUMBER,
3758: c_lane_id NUMBER, c_schedule_id NUMBER)
3759: IS
3760: SELECT ffct.total_amount, ffct.currency_code
3761: FROM fte_freight_costs_temp ffct, wsh_freight_cost_types wfct
3762: WHERE ffct.freight_cost_type_id = wfct.freight_cost_type_id
3763: AND wfct.name='SUMMARY'
3764: AND ffct.trip_id = c_trip_id
3765: AND ffct.comparison_request_id = c_request_id