[Home] [Help]
604: Wnd.Ignore_For_Planning -- OTM R12 : unassign delivery detail
605: FROM WSH_DELIVERY_DETAILS Wdd,
606: WSH_DELIVERY_ASSIGNMENTS Wda,
607: WSH_NEW_DELIVERIES Wnd,
608: Wsh_Freight_Costs Wfc,
609: Wsh_Tmp Tmp
610: WHERE Wdd.Container_Flag = 'N'
611: AND Wdd.Released_Status IN ( 'R', 'N', 'X', 'Y', 'S', 'B' )
612: AND Wdd.Customer_id = p_customer_id
963: IF ( G_FTE_INSTALLED = 'Y' AND
964: l_freightCostRowidTab.COUNT > 0 )
965: THEN
966: FORALL delCnt in l_freightCostRowidTab.FIRST..l_freightCostRowidTab.LAST
967: DELETE FROM Wsh_Freight_Costs
968: WHERE Rowid = l_freightCostRowidTab(delCnt);
969: END IF;
970:
971: IF ( G_PROFILE_VAL IS NOT NULL AND G_PROFILE_VAL = 'Y' )
1735:
1736: IF ( G_FTE_INSTALLED = 'Y' AND l_deliveryLegIdTab.COUNT > 0)
1737: THEN
1738: FORALL delCnt IN l_deliveryLegIdTab.FIRST..l_deliveryLegIdTab.LAST
1739: DELETE FROM Wsh_Freight_Costs
1740: WHERE Delivery_Leg_Id = l_deliveryLegIdTab(delCnt);
1741: END IF;
1742: END IF;
1743:
1958:
1959: IF l_dlvy_id_tab.count > 0 THEN
1960: -- Delivery Legs
1961: FORALL delCnt IN l_dlvy_id_tab.FIRST..l_dlvy_id_tab.LAST
1962: DELETE FROM Wsh_Freight_Costs
1963: WHERE Delivery_Leg_Id IN
1964: (SELECT wdl.delivery_leg_id
1965: FROM wsh_delivery_legs wdl
1966: WHERE wdl.delivery_id = l_dlvy_id_tab(delCnt))
1967: AND freight_cost_type_id = l_frcost_type_id;
1968:
1969: -- Delivery
1970: FORALL delCnt IN l_dlvy_id_tab.FIRST..l_dlvy_id_tab.LAST
1971: DELETE FROM Wsh_Freight_Costs
1972: WHERE Delivery_Id = l_dlvy_id_tab(delCnt)
1973: AND freight_cost_type_id = l_frcost_type_id;
1974: END IF;
1975: END IF; -- if l_gc3_is_installed