APPS.FTE_PO_INTEGRATION_GRP dependencies on FTE_ESTIMATE_RATES_DEL_TEMP

Line 129: FROM fte_estimate_rates_del_temp tmp,

125: /* find all deliveries for no rates or partial rates for all deliveries for the given rcv ship header id */
126:
127: cursor c_get_no_rates_del IS
128: select distinct tmp.delivery_id
129: FROM fte_estimate_rates_del_temp tmp,
130: WSH_DELIVERY_LEGS wdl
131: WHERE tmp.DELIVERY_ID = WDL.DELIVERY_ID
132: AND ( NVL(WDL.REPRICE_REQUIRED,'N') = 'Y'
133: OR NOT EXISTS

Line 153: -- fte_estimate_rates_del_temp contain the delivery list for the given shipment header id

149:
150:
151: /* find all receipts for those receipt lines where there is no rates available or
152: partial rates available or available rates needs to re-rated */
153: -- fte_estimate_rates_del_temp contain the delivery list for the given shipment header id
154: cursor c_get_receipts_no_rates IS
155: select distinct wdd.vendor_id,
156: wdd.ship_from_site_id vendor_site_id,
157: wdd.source_line_id,

Line 162: fte_estimate_rates_del_temp tmp

158: wdd.po_shipment_line_id,
159: wdd.rcv_shipment_line_id
160: FROM WSH_DELIVERY_DETAILS WDD,
161: WSH_DELIVERY_ASSIGNMENTS_V WDA2,
162: fte_estimate_rates_del_temp tmp
163: WHERE WDA2.delivery_detail_id = wdd.delivery_detail_id
164: AND tmp.RATE_AVAILABLE_FLAG = 'N' and tmp.MATCHING_FLAG = 'Y'
165: AND wda2.delivery_id = tmp.delivery_id
166: UNION

Line 175: fte_estimate_rates_del_temp tmp2

171: rsl.shipment_line_id
172: FROM WSH_DELIVERY_DETAILS WDD,
173: WSH_DELIVERY_ASSIGNMENTS_V WDA,
174: rcv_shipment_lines rsl,
175: fte_estimate_rates_del_temp tmp2
176: WHERE WDA.delivery_detail_id = wdd.delivery_detail_id
177: AND rsl.po_line_location_id = wdd.PO_SHIPMENT_LINE_ID
178: and rsl.po_line_id = wdd.source_line_id
179: and wdd.source_code = 'PO'

Line 216: fte_estimate_rates_del_temp tmp

212: WSH_DELIVERY_ASSIGNMENTS_V WDA,
213: WSH_TRIPS WT,
214: WSH_TRIP_STOPS WTS1,
215: WSH_TRIP_STOPS WTS2,
216: fte_estimate_rates_del_temp tmp
217: WHERE WND.DELIVERY_ID = WDL.DELIVERY_ID
218: AND WDA.DELIVERY_ID = WND.DELIVERY_ID
219: AND WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
220: AND WDL.DELIVERY_LEG_ID=WFC.DELIVERY_LEG_ID

Line 270: fte_estimate_rates_del_temp tmp

266: WSH_DELIVERY_ASSIGNMENTS_V WDA,
267: WSH_TRIPS WT,
268: WSH_TRIP_STOPS WTS1,
269: WSH_TRIP_STOPS WTS2,
270: fte_estimate_rates_del_temp tmp
271: WHERE WND.DELIVERY_ID = WDL.DELIVERY_ID
272: AND WDA.DELIVERY_ID = WND.DELIVERY_ID
273: AND WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
274: AND WDL.DELIVERY_LEG_ID=WFC.DELIVERY_LEG_ID

Line 488: INSERT INTO fte_estimate_rates_del_temp(DELIVERY_ID,RATE_AVAILABLE_FLAG,MATCHING_FLAG)

484: IF l_del_count > 0 then
485: --{
486: l_delivery_exist_flag := 'Y';
487: FORALL j IN 1..l_del_count
488: INSERT INTO fte_estimate_rates_del_temp(DELIVERY_ID,RATE_AVAILABLE_FLAG,MATCHING_FLAG)
489: VALUES (l_del_table(j),l_rate_available_table(j),l_matching_table(j));
490:
491: -- find all deliveries for no rates or partial rates (matching and mismatching shipments)
492: OPEN c_get_no_rates_del;

Line 501: UPDATE fte_estimate_rates_del_temp

497: --
498: --Updating those deliveries with RATE_AVAILABLE_FLAG ='N'
499: IF l_no_rate_del_count > 0 then
500: FORALL j IN 1..l_no_rate_del_count
501: UPDATE fte_estimate_rates_del_temp
502: SET RATE_AVAILABLE_FLAG ='N'
503: WHERE DELIVERY_ID = l_del_table(j);
504: END IF;
505: --}

Line 993: delete from fte_estimate_rates_del_temp;

989: END LOOP;
990: COMMIT;
991: */
992: -- clearing the cache after each call.
993: delete from fte_estimate_rates_del_temp;
994: /* end of temporary section to be removed after UT */
995: --dbms_output.put_line(' just before calling api_post_call ');
996: wsh_util_core.api_post_call(
997: p_return_status =>x_return_status,