APPS.WSH_PARTY_MERGE dependencies on HZ_CUST_SITE_USES_ALL

Line 1373: hz_cust_site_uses_all su

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
1376: and wda.delivery_detail_id = wdd.delivery_detail_id
1377: and nvl(wdd.line_direction, 'O') in ( 'O', 'IO' )

Line 1391: hz_cust_site_uses_all su

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
1394: and wda.delivery_detail_id = wdd.delivery_detail_id
1395: and nvl(wdd.line_direction, 'O') in ( 'O', 'IO' )

Line 1613: HZ_CUST_SITE_USES_ALL SU

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
1616: AND WDD.Container_Flag = 'N'
1617: AND NVL(WDD.Line_Direction, 'O') in ( 'O', 'IO' )

Line 1643: HZ_CUST_SITE_USES_ALL SU

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
1645: AND CA.Party_Site_Id = p_party_site_id
1646: AND WDD.Container_Flag = 'N'
1647: AND NVL(WDD.Line_Direction, 'O') in ( 'O', 'IO' )

Line 1714: HZ_CUST_SITE_USES_ALL SU

1710: IS
1711: SELECT WDD.Rowid
1712: FROM WSH_DELIVERY_DETAILS WDD,
1713: HZ_CUST_ACCT_SITES_ALL CA,
1714: HZ_CUST_SITE_USES_ALL SU
1715: WHERE SU.Cust_Acct_Site_Id = CA.Cust_Acct_Site_Id
1716: AND CA.Party_Site_Id = p_party_site_id
1717: AND NVL(WDD.Line_Direction, 'O') in ( 'O', 'IO' )
1718: AND WDD.Deliver_To_Location_id = p_location_id

Line 1735: HZ_CUST_SITE_USES_ALL SU

1731: START WITH wda.delivery_detail_id IN
1732: ( SELECT WDD.Delivery_Detail_Id
1733: FROM WSH_DELIVERY_DETAILS WDD,
1734: HZ_CUST_ACCT_SITES_ALL CA,
1735: HZ_CUST_SITE_USES_ALL SU
1736: WHERE SU.Cust_Acct_Site_Id = CA.Cust_Acct_Site_Id
1737: AND CA.Party_Site_Id = p_party_site_id
1738: AND WDD.Container_Flag = 'N'
1739: AND NVL(WDD.Line_Direction, 'O') in ( 'O', 'IO' )