APPS.WSH_PARTY_MERGE dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 1371: wsh_delivery_assignments_v wda,

1367: CURSOR C1
1368: IS
1369: SELECT DISTINCT wdd.organization_id
1370: from wsh_delivery_details wdd,
1371: wsh_delivery_assignments_v wda,
1372: hz_cust_acct_sites_all ca,
1373: hz_cust_site_uses_all su
1374: where wda.parent_delivery_detail_id is not null
1375: and wda.delivery_id is null

Line 1389: wsh_delivery_assignments_v wda,

1385: CURSOR C2
1386: IS
1387: SELECT DISTINCT wdd.organization_id
1388: from wsh_delivery_details wdd,
1389: wsh_delivery_assignments_v wda,
1390: hz_cust_acct_sites_all ca,
1391: hz_cust_site_uses_all su
1392: where wda.parent_delivery_detail_id is not null
1393: and wda.delivery_id is not null

Line 1405: wsh_delivery_assignments_v asgn

1401: and ca.party_site_id = p_party_site_id
1402: and exists
1403: ( select 'X'
1404: from wsh_delivery_details det,
1405: wsh_delivery_assignments_v asgn
1406: where det.ship_to_site_use_id <> wdd.ship_to_site_use_id
1407: and det.delivery_detail_id = asgn.delivery_detail_id
1408: and asgn.delivery_id = wda.delivery_id );
1409:

Line 1608: WSH_DELIVERY_ASSIGNMENTS_V WDA,

1604: Wdd.Net_Weight, Wdd.Gross_Weight, Wdd.Volume,
1605: Wdd.Weight_Uom_code, Wdd.Volume_Uom_Code, Wdd.Inventory_Item_Id,
1606: Wdd.Organization_Id, WDA.Rowid Wda_Rowid
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,

Line 1640: WSH_DELIVERY_ASSIGNMENTS_V WDA,

1636: Wdd.Weight_Uom_code, Wdd.Volume_Uom_Code, Wdd.Inventory_Item_Id,
1637: Wdd.Organization_Id, Wnd.Name Delivery_Name,
1638: Wdd.Move_Order_Line_Id, Wdd.Released_Status
1639: FROM WSH_DELIVERY_DETAILS WDD,
1640: WSH_DELIVERY_ASSIGNMENTS_V WDA,
1641: WSH_NEW_DELIVERIES WND,
1642: HZ_CUST_ACCT_SITES_ALL CA,
1643: HZ_CUST_SITE_USES_ALL SU
1644: WHERE SU.Cust_Acct_Site_Id = CA.Cust_Acct_Site_Id

Line 1658: FROM WSH_DELIVERY_ASSIGNMENTS_V WDA1,

1654: AND WDA.delivery_id is not null
1655: AND WND.Delivery_Id = WDA.Delivery_Id
1656: AND exists (
1657: SELECT 'x'
1658: FROM WSH_DELIVERY_ASSIGNMENTS_V WDA1,
1659: WSH_DELIVERY_DETAILS WDD1
1660: WHERE WDD1.DELIVERY_DETAIL_ID = WDA1.DELIVERY_DETAIL_ID
1661: AND WDD1.Container_Flag = 'N'
1662: AND WDA1.Delivery_Id = WND.Delivery_Id

Line 1670: Wsh_Delivery_Assignments_V Wda,

1666: CURSOR Get_Delivery_Containers
1667: IS
1668: SELECT Wdd.Rowid
1669: FROM Wsh_Delivery_Details Wdd,
1670: Wsh_Delivery_Assignments_V Wda,
1671: Wsh_Tmp Tmp
1672: WHERE Wdd.container_flag = 'Y'
1673: AND NVL(WDD.Line_Direction, 'O') in ( 'O', 'IO' )
1674: AND Wdd.delivery_detail_id = Wda.Delivery_Detail_Id

Line 1728: FROM WSH_DELIVERY_ASSIGNMENTS_V WDA

1724: -- Cursor to update deliver_to_location for container records.
1725: CURSOR Get_Del_Loc_Cont_Details ( p_party_site_id NUMBER, p_location_id NUMBER )
1726: IS
1727: SELECT WDA.Parent_Delivery_Detail_Id
1728: FROM WSH_DELIVERY_ASSIGNMENTS_V WDA
1729: WHERE WDA.Parent_Delivery_Detail_Id IS NOT NULL
1730: CONNECT BY PRIOR WDA.Parent_Delivery_Detail_Id = WDA.Delivery_Detail_Id
1731: START WITH wda.delivery_detail_id IN
1732: ( SELECT WDD.Delivery_Detail_Id