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 2795: FROM DUAL

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

Line 3746: SELECT 1 FROM DUAL

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

Line 3846: SELECT 1 FROM DUAL

3842: Set_Num IN NUMBER,
3843: Process_Mode IN VARCHAR2 )
3844: IS
3845: CURSOR C1 IS
3846: SELECT 1 FROM DUAL
3847: WHERE EXISTS
3848: ( SELECT 'x'
3849: FROM mtl_client_parameters_v mcp,
3850: ra_customer_merges rcm