APPS.WSH_PARTY_MERGE dependencies on WSH_TRIP_STOPS

Line 1564: -- Wsh_Trip_Stops tables for Unshipped delivery lines during party

1560: -- x_return_status Returns the status of call
1561: --
1562: -- COMMENT :
1563: -- To update locations in Wsh_Delivery_Details, Wsh_New_Deliveries,
1564: -- Wsh_Trip_Stops tables for Unshipped delivery lines during party
1565: -- merge. Also updates Wsh_Picking_Rules tables during party merge.
1566: -- ============================================================================
1567: PROCEDURE merge_location(
1568: p_entity_name IN VARCHAR2,

Line 1611: WSH_TRIP_STOPS WTS,

1607: FROM WSH_DELIVERY_DETAILS WDD,
1608: WSH_DELIVERY_ASSIGNMENTS_V WDA,
1609: WSH_NEW_DELIVERIES WND,
1610: WSH_DELIVERY_LEGS WDL,
1611: WSH_TRIP_STOPS WTS,
1612: HZ_CUST_ACCT_SITES_ALL CA,
1613: HZ_CUST_SITE_USES_ALL SU
1614: WHERE SU.Cust_Acct_Site_Id = CA.Cust_Acct_Site_Id
1615: AND CA.Party_Site_Id = p_party_site_id

Line 1687: FROM Wsh_Trip_Stops Wts,

1683: SELECT Wdl.Delivery_Id, Wts.Stop_Id, Wts.Trip_Id,
1684: Wdl.Delivery_Leg_Id, Wnd.organization_id,
1685: Wnd.Net_Weight, Wnd.Gross_Weight, Wnd.Volume,
1686: Wdl.Rowid, Tmp.Rowid
1687: FROM Wsh_Trip_Stops Wts,
1688: Wsh_New_Deliveries Wnd,
1689: Wsh_Delivery_Legs Wdl,
1690: Wsh_Tmp Tmp
1691: WHERE Wnd.Ultimate_DropOff_Location_Id = p_to_location_id

Line 2631: UPDATE WSH_TRIP_STOPS Wts

2627:
2628: END LOOP; -- } Loop for logging Expceptions
2629: END IF; -- } Log Exception
2630:
2631: UPDATE WSH_TRIP_STOPS Wts
2632: SET stop_location_id = l_to_location_id,
2633: last_update_date = SYSDATE,
2634: last_updated_by = fnd_global.user_id,
2635: last_update_login = fnd_global.conc_login_id,