DBA Data[Home] [Help]

APPS.WSH_PARTY_MERGE dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1372: hz_cust_acct_sites_all ca,

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
1376: and wda.delivery_detail_id = wdd.delivery_detail_id

Line 1390: hz_cust_acct_sites_all ca,

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
1394: and wda.delivery_detail_id = wdd.delivery_detail_id

Line 1612: HZ_CUST_ACCT_SITES_ALL CA,

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
1616: AND WDD.Container_Flag = 'N'

Line 1642: HZ_CUST_ACCT_SITES_ALL CA,

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
1645: AND CA.Party_Site_Id = p_party_site_id
1646: AND WDD.Container_Flag = 'N'

Line 1713: HZ_CUST_ACCT_SITES_ALL CA,

1709: CURSOR Get_Deliver_Loc_Details ( p_party_site_id NUMBER, p_location_id NUMBER )
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' )

Line 1734: HZ_CUST_ACCT_SITES_ALL CA,

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
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'

Line 1972: -- in HZ_CUST_ACCT_SITES_ALL API before calling our API.

1968:
1969: -- Get Shipping details based on ship_to_location for which the location
1970: -- has to be updated during Party Merge.
1971: -- Passing l_to_party_site_id, since party_site_id is already updated
1972: -- in HZ_CUST_ACCT_SITES_ALL API before calling our API.
1973: OPEN Get_Wsh_Details ( l_to_party_site_id, l_from_location_id );
1974:
1975: LOOP -- {
1976: FETCH Get_Wsh_Details BULK COLLECT INTO

Line 2667: -- in HZ_CUST_ACCT_SITES_ALL API before calling our API.

2663:
2664: -- Get Shipping details based on deliver_to_location for which the location
2665: -- has to be updated during party merge.
2666: -- Passing l_to_party_site_id, since party_site_id is already updated
2667: -- in HZ_CUST_ACCT_SITES_ALL API before calling our API.
2668: OPEN Get_Deliver_Loc_Details ( l_to_party_site_id, l_from_location_id );
2669:
2670: LOOP -- {
2671: FETCH Get_Deliver_Loc_Details BULK COLLECT INTO

Line 2772: FROM HZ_CUST_ACCT_SITES_ALL CA

2768: program_update_date = SYSDATE
2769: WHERE ship_to_location_id = l_from_location_id
2770: AND EXISTS
2771: ( SELECT 'X'
2772: FROM HZ_CUST_ACCT_SITES_ALL CA
2773: WHERE CA.Party_Site_Id = l_to_party_site_id
2774: AND CA.Cust_Account_Id = WPR.Customer_Id );
2775:
2776: --