eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_CUST_MERGE dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 554: Wsh_Delivery_Assignments DelAsgn,

550: IS
551: SELECT Det.Delivery_Detail_Id, Det.Rowid,
552: Dlvy.Customer_Id
553: FROM Wsh_Delivery_Details Det,
554: Wsh_Delivery_Assignments DelAsgn,
555: Wsh_New_Deliveries Dlvy
556: WHERE Dlvy.Delivery_Id = DelAsgn.Delivery_Id
557: AND DelAsgn.Delivery_Detail_Id = Det.Delivery_Detail_Id
558: AND Det.Container_Flag = 'Y'

Line 561: FROM Wsh_Delivery_Assignments Asgn

557: AND DelAsgn.Delivery_Detail_Id = Det.Delivery_Detail_Id
558: AND Det.Container_Flag = 'Y'
559: AND Det.Delivery_Detail_Id IN
560: ( SELECT Asgn.Parent_Delivery_Detail_Id
561: FROM Wsh_Delivery_Assignments Asgn
562: WHERE Asgn.Parent_Delivery_Detail_Id IS NOT NULL
563: CONNECT BY PRIOR Asgn.Parent_Delivery_Detail_Id = Asgn.Delivery_Detail_Id
564: START WITH Asgn.delivery_detail_id IN
565: ( SELECT Wdd.Delivery_Detail_Id

Line 567: WSH_DELIVERY_ASSIGNMENTS Wda,

563: CONNECT BY PRIOR Asgn.Parent_Delivery_Detail_Id = Asgn.Delivery_Detail_Id
564: START WITH Asgn.delivery_detail_id IN
565: ( SELECT Wdd.Delivery_Detail_Id
566: FROM WSH_DELIVERY_DETAILS Wdd,
567: WSH_DELIVERY_ASSIGNMENTS Wda,
568: WSH_NEW_DELIVERIES Wnd,
569: Wsh_Tmp Tmp
570: WHERE Wdd.Container_Flag = 'N'
571: AND Wdd.Released_Status IN ( 'R', 'N', 'X', 'Y', 'S', 'B' )

Line 583: FROM WSH_DELIVERY_ASSIGNMENTS WDA1,

579: AND Wnd.Status_Code = 'OP'
580: AND Wnd.Delivery_Id = Tmp.Column1
581: AND exists
582: ( SELECT 'x'
583: FROM WSH_DELIVERY_ASSIGNMENTS WDA1,
584: WSH_DELIVERY_DETAILS WDD1
585: WHERE WDD1.DELIVERY_DETAIL_ID = WDA1.DELIVERY_DETAIL_ID
586: AND WDD1.Container_Flag = 'N'
587: AND WDA1.Delivery_Id = WND.Delivery_Id

Line 606: WSH_DELIVERY_ASSIGNMENTS Wda,

602: Wdd.Organization_Id, Wdd.Inventory_Item_Id,
603: Wdd.Move_Order_Line_Id, Wdd.Released_Status,
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'

Line 625: FROM WSH_DELIVERY_ASSIGNMENTS WDA1,

621: AND Wnd.Status_Code = 'OP'
622: AND Wnd.Delivery_Id = Tmp.Column1
623: AND exists (
624: SELECT 'x'
625: FROM WSH_DELIVERY_ASSIGNMENTS WDA1,
626: WSH_DELIVERY_DETAILS WDD1
627: WHERE WDD1.DELIVERY_DETAIL_ID = WDA1.DELIVERY_DETAIL_ID
628: AND WDD1.Container_Flag = 'N'
629: AND WDA1.Delivery_Id = WND.Delivery_Id

Line 796: UPDATE WSH_DELIVERY_ASSIGNMENTS

792: RAISE Unassign_Del_Exp;
793: END IF;
794:
795: FORALL unassignDelCnt IN l_deliveryAssgRowidTab.FIRST..l_deliveryAssgRowidTab.LAST
796: UPDATE WSH_DELIVERY_ASSIGNMENTS
797: SET parent_delivery_detail_id = null,
798: delivery_id = null,
799: last_update_date = SYSDATE,
800: last_updated_by = fnd_global.user_id,

Line 807: setARMessageRowCount( 'WSH_DELIVERY_ASSIGNMENTS', SQL%ROWCOUNT );

803: program_id = fnd_global.conc_program_id,
804: program_update_date = SYSDATE
805: WHERE rowid = l_deliveryAssgRowidTab(unassignDelCnt);
806:
807: setARMessageRowCount( 'WSH_DELIVERY_ASSIGNMENTS', SQL%ROWCOUNT );
808:
809: -- OTM R12 : unassign delivery detail
810: -- container_flag is always 'N' for rows in l_deliveryAssgRowidTab
811: --

Line 977: p_table_name => 'WSH_DELIVERY_ASSIGNMENTS',

973: l_return_status := NULL;
974:
975: Insert_Log_Table (
976: p_id_tab => l_deliveryDetailIdTab,
977: p_table_name => 'WSH_DELIVERY_ASSIGNMENTS',
978: p_req_id => p_req_id,
979: x_return_status => l_return_status );
980:
981: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )

Line 1224: Wsh_Delivery_Assignments Wda,

1220: CURSOR Get_Delivery_Containers
1221: IS
1222: SELECT Wdd.Delivery_Detail_Id, Wdd.Rowid
1223: FROM Wsh_Delivery_Details Wdd,
1224: Wsh_Delivery_Assignments Wda,
1225: Wsh_Tmp Tmp
1226: WHERE Wdd.Container_Flag = 'Y'
1227: AND Wdd.Delivery_Detail_Id = Wda.Parent_Delivery_Detail_Id
1228: AND Parent_Delivery_Detail_Id IS NOT NULL

Line 1283: FROM wsh_delivery_assignments wda,

1279: AND wnd.status_code = 'OP'
1280: AND NOT EXISTS
1281: (
1282: SELECT 1
1283: FROM wsh_delivery_assignments wda,
1284: wsh_delivery_details wdd
1285: WHERE wda.delivery_id = wnd.delivery_id
1286: AND wda.delivery_detail_id = wdd.delivery_detail_id
1287: AND wdd.container_flag = 'N'

Line 2215: ( SELECT 'x' FROM Wsh_Delivery_Assignments Wda

2211: WHERE nvl(Wnd.Customer_Id, p_customer_id) = p_customer_id
2212: AND Wnd.Ultimate_Dropoff_Location_Id = p_location_id
2213: AND Wnd.Status_Code = 'OP'
2214: AND NOT EXISTS
2215: ( SELECT 'x' FROM Wsh_Delivery_Assignments Wda
2216: WHERE Wda.Delivery_Id = Wnd.Delivery_Id )
2217: FOR UPDATE OF Wnd.Delivery_Id NOWAIT;
2218:
2219: -- Cursor to fetch deliveries which contains only containers under it.

Line 2227: Wsh_Delivery_Assignments Asg,

2223: IS
2224: SELECT Det.Delivery_Detail_Id, Dlvy.Delivery_Id,
2225: Det.Rowid, Dlvy.Rowid
2226: FROM Wsh_Delivery_Details Det,
2227: Wsh_Delivery_Assignments Asg,
2228: Wsh_New_Deliveries Dlvy
2229: WHERE Det.Delivery_Detail_Id = Asg.Delivery_Detail_Id
2230: AND Asg.Delivery_Id = Dlvy.Delivery_Id
2231: AND Dlvy.Delivery_Id in

Line 2234: Wsh_Delivery_Assignments Wda,

2230: AND Asg.Delivery_Id = Dlvy.Delivery_Id
2231: AND Dlvy.Delivery_Id in
2232: ( SELECT Wnd.Delivery_Id
2233: FROM Wsh_Delivery_Details Wdd,
2234: Wsh_Delivery_Assignments Wda,
2235: Wsh_New_Deliveries Wnd
2236: WHERE Wdd.Container_Flag = 'Y'
2237: AND Wdd.Delivery_Detail_Id = Wda.Delivery_Detail_id
2238: AND Wda.Delivery_Id = Wnd.Delivery_Id

Line 2244: FROM Wsh_Delivery_Assignments Asgn

2240: AND Wnd.Ultimate_Dropoff_Location_Id = p_location_id
2241: AND Wnd.Status_Code = 'OP'
2242: AND NOT EXISTS
2243: ( SELECT 'X'
2244: FROM Wsh_Delivery_Assignments Asgn
2245: WHERE Asgn.Parent_Delivery_Detail_Id = Wdd.Delivery_Detail_Id
2246: AND Asgn.Delivery_Id = Wnd.Delivery_Id )
2247: AND NOT EXISTS
2248: ( SELECT 'X'

Line 2250: Wsh_Delivery_Assignments da

2246: AND Asgn.Delivery_Id = Wnd.Delivery_Id )
2247: AND NOT EXISTS
2248: ( SELECT 'X'
2249: FROM Wsh_Delivery_Details dd,
2250: Wsh_Delivery_Assignments da
2251: WHERE dd.Container_Flag = 'N'
2252: AND dd.Delivery_Detail_Id = da.Delivery_Detail_Id
2253: AND da.Delivery_Id = Wnd.Delivery_Id ) )
2254: FOR UPDATE OF Det.Delivery_Detail_Id, Dlvy.Delivery_Id NOWAIT;

Line 2507: Wsh_Delivery_Assignments WDA,

2503: WDD.Volume, Wdd.Weight_Uom_code, Wdd.Volume_Uom_Code,
2504: Wdd.Inventory_Item_Id, Wdd.Organization_Id,
2505: WDD.Rowid, WDA.Rowid
2506: FROM Wsh_Delivery_Details WDD,
2507: Wsh_Delivery_Assignments WDA,
2508: Wsh_New_Deliveries WND,
2509: Wsh_Delivery_Legs WDL,
2510: Wsh_Trip_Stops WTS
2511: WHERE WTS.Stop_id (+) = WDL.Drop_Off_Stop_Id

Line 2687: UPDATE WSH_DELIVERY_ASSIGNMENTS

2683:
2684: -- Unassign delivery details from containers if it is packed and not
2685: -- assigned to a delivery.
2686: FORALL unassignCnt IN l_deliveryAssgRowidTab.FIRST..l_deliveryAssgRowidTab.LAST
2687: UPDATE WSH_DELIVERY_ASSIGNMENTS
2688: SET parent_delivery_detail_id = null,
2689: last_update_date = SYSDATE,
2690: last_updated_by = arp_standard.profile.user_id,
2691: last_update_login = arp_standard.profile.last_update_login,

Line 2700: setARMessageRowCount( 'WSH_DELIVERY_ASSIGNMENTS', SQL%ROWCOUNT );

2696: AND Parent_Delivery_Detail_Id IS NOT NULL
2697: AND Delivery_Id IS NULL;
2698:
2699: --
2700: setARMessageRowCount( 'WSH_DELIVERY_ASSIGNMENTS', SQL%ROWCOUNT );
2701:
2702: l_return_status := NULL;
2703: l_dummyIdTab.delete;
2704:

Line 2923: FROM Wsh_Delivery_Assignments Wda

2919: FROM Wsh_Delivery_Details Det
2920: WHERE Det.Container_Flag = 'Y'
2921: AND Det.Delivery_Detail_Id IN
2922: ( SELECT Wda.Parent_Delivery_Detail_Id
2923: FROM Wsh_Delivery_Assignments Wda
2924: WHERE Wda.Parent_Delivery_Detail_Id IS NOT NULL
2925: CONNECT BY PRIOR Wda.Parent_Delivery_Detail_Id = Wda.Delivery_Detail_Id
2926: START WITH wda.delivery_detail_id IN
2927: ( SELECT WDD.Delivery_Detail_Id

Line 2929: Wsh_Delivery_Assignments WDA,

2925: CONNECT BY PRIOR Wda.Parent_Delivery_Detail_Id = Wda.Delivery_Detail_Id
2926: START WITH wda.delivery_detail_id IN
2927: ( SELECT WDD.Delivery_Detail_Id
2928: FROM Wsh_Delivery_Details WDD,
2929: Wsh_Delivery_Assignments WDA,
2930: Wsh_New_Deliveries WND
2931: WHERE Wnd.Status_Code in ( 'CO', 'CL', 'IT' )
2932: -- Added Parent_Delivery_Detail_Id for Perf. improvement,
2933: -- as per perf. team suggestion.

Line 2954: Wsh_Delivery_Assignments WDA,

2950: p_location_id NUMBER )
2951: IS
2952: SELECT Wdd.Delivery_Detail_Id, Wdd.Rowid
2953: FROM Wsh_Delivery_Details WDD,
2954: Wsh_Delivery_Assignments WDA,
2955: Wsh_New_Deliveries WND
2956: WHERE Wnd.Status_Code in ( 'CO', 'CL', 'IT' )
2957: AND Wnd.Delivery_Id = Wda.Delivery_Id
2958: AND Wda.Delivery_Detail_Id = Wdd.Delivery_Detail_Id

Line 3753: wsh_delivery_assignments wda,

3749: SELECT 1 FROM DUAL
3750: WHERE EXISTS
3751: ( SELECT 'x'
3752: FROM wsh_delivery_details wdd,
3753: wsh_delivery_assignments wda,
3754: ra_customer_merges rcm,
3755: mtl_parameters mtl
3756: WHERE mtl.wms_enabled_flag = 'Y'
3757: AND mtl.organization_id = wdd.organization_id