[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
960: IF ( G_FTE_INSTALLED = 'Y' AND
961: l_freightCostRowidTab.COUNT > 0 )
962: THEN
963: FORALL delCnt in l_freightCostRowidTab.FIRST..l_freightCostRowidTab.LAST
964: DELETE FROM Wsh_Freight_Costs
965: WHERE Rowid = l_freightCostRowidTab(delCnt);
966: END IF;
967:
968: IF ( G_PROFILE_VAL IS NOT NULL AND G_PROFILE_VAL = 'Y' )
1732:
1733: IF ( G_FTE_INSTALLED = 'Y' AND l_deliveryLegIdTab.COUNT > 0)
1734: THEN
1735: FORALL delCnt IN l_deliveryLegIdTab.FIRST..l_deliveryLegIdTab.LAST
1736: DELETE FROM Wsh_Freight_Costs
1737: WHERE Delivery_Leg_Id = l_deliveryLegIdTab(delCnt);
1738: END IF;
1739: END IF;
1740:
1955:
1956: IF l_dlvy_id_tab.count > 0 THEN
1957: -- Delivery Legs
1958: FORALL delCnt IN l_dlvy_id_tab.FIRST..l_dlvy_id_tab.LAST
1959: DELETE FROM Wsh_Freight_Costs
1960: WHERE Delivery_Leg_Id IN
1961: (SELECT wdl.delivery_leg_id
1962: FROM wsh_delivery_legs wdl
1963: WHERE wdl.delivery_id = l_dlvy_id_tab(delCnt))
1964: AND freight_cost_type_id = l_frcost_type_id;
1965:
1966: -- Delivery
1967: FORALL delCnt IN l_dlvy_id_tab.FIRST..l_dlvy_id_tab.LAST
1968: DELETE FROM Wsh_Freight_Costs
1969: WHERE Delivery_Id = l_dlvy_id_tab(delCnt)
1970: AND freight_cost_type_id = l_frcost_type_id;
1971: END IF;
1972: END IF; -- if l_gc3_is_installed