DBA Data[Home] [Help]

APPS.WSH_CUST_MERGE dependencies on DUAL

Line 635: FROM Dual;

631: FOR UPDATE OF Wda.Delivery_Detail_Id, Wfc.Freight_Cost_Id NOWAIT;
632:
633: CURSOR Get_Grouping_Id is
634: SELECT Wsh_Delivery_Group_S.NEXTVAL
635: FROM Dual;
636:
637: l_grossWeightTab g_number_tbl_type;
638: l_netWeightTab g_number_tbl_type;
639: l_volumeTab g_number_tbl_type;

Line 2798: FROM DUAL

2794: -- Dulplicate entries are avoided using NOT EXISTS condition
2795: FORALL insCnt in l_deliveryIdTab.FIRST..l_deliveryIdTab.LAST
2796: INSERT INTO Wsh_Tmp ( Column1, Column2, Column3 )
2797: SELECT l_deliveryIdTab(insCnt), l_stopIdTab(insCnt), l_deliveryDetailIdTab(insCnt)
2798: FROM DUAL
2799: WHERE l_deliveryIdTab(insCnt) IS NOT NULL
2800: --Start of fix for bug 5900667
2801: --Populate details of delivery/stop into table only if location matches.
2802: AND EXISTS

Line 3749: SELECT 1 FROM DUAL

3745: IS
3746: /* Bug 7117470 According to vedo condition, Check_Wms_Details should raise
3747: exception only if Delivery_Detail is WMS Enabled and Staged ('Y') */
3748: CURSOR C1 IS
3749: SELECT 1 FROM DUAL
3750: WHERE EXISTS
3751: ( SELECT 'x'
3752: FROM wsh_delivery_details wdd,
3753: wsh_delivery_assignments wda,