APPS.CSTPOMLD dependencies on HZ_CUST_SITE_USES_ALL

Line 1712: -- Changed to use hz_cust_site_uses_all instead of ra_site_uses_all

1708:
1709: /*---------------------------------------------------------------+
1710: | Update territory_id
1711: +---------------------------------------------------------------*/
1712: -- Changed to use hz_cust_site_uses_all instead of ra_site_uses_all
1713: -- as part of Uptake for R12
1714:
1715: l_stmt_id := 140;
1716:

Line 1720: FROM hz_cust_site_uses_all hsu -- Object ra_site_uses_all obsoleted in R12

1716:
1717: UPDATE CST_BIS_MARGIN_SUMMARY temp
1718: SET territory_id =
1719: (SELECT territory_id
1720: FROM hz_cust_site_uses_all hsu -- Object ra_site_uses_all obsoleted in R12
1721: WHERE NVL(hsu.org_id, -999) = NVL(l_ou_id, NVL(hsu.org_id, -999))
1722: AND hsu.site_use_id = temp.ship_to_site_use_id )
1723: -- ra_site_uses_all.site_use_id migrated to hz_cust_site_uses_all.site_use_id
1724: WHERE

Line 1723: -- ra_site_uses_all.site_use_id migrated to hz_cust_site_uses_all.site_use_id

1719: (SELECT territory_id
1720: FROM hz_cust_site_uses_all hsu -- Object ra_site_uses_all obsoleted in R12
1721: WHERE NVL(hsu.org_id, -999) = NVL(l_ou_id, NVL(hsu.org_id, -999))
1722: AND hsu.site_use_id = temp.ship_to_site_use_id )
1723: -- ra_site_uses_all.site_use_id migrated to hz_cust_site_uses_all.site_use_id
1724: WHERE
1725: ship_to_site_use_id is not null
1726: and gl_date between l_from_date and l_to_date
1727: and build_id = l_build_id;

Line 1769: -- Changed to use hz_cust_accounts, hz_parties, hz_cust_site_uses_all,

1765:
1766: /*---------------------------------------------------------------+
1767: | Update bill to customer name
1768: +---------------------------------------------------------------*/
1769: -- Changed to use hz_cust_accounts, hz_parties, hz_cust_site_uses_all,
1770: -- hz_cust_acct_sites_all as part of Uptake for R12
1771:
1772: l_stmt_id := 170;
1773:

Line 1779: , hz_cust_site_uses_all hsu

1775: SET bill_to_customer_name =
1776: (SELECT hp.party_name
1777: FROM hz_cust_accounts hca
1778: , hz_parties hp
1779: , hz_cust_site_uses_all hsu
1780: , hz_cust_acct_sites_all ha
1781: WHERE
1782: NVL(ha.org_id, -999) = NVL(l_ou_id,NVL(ha.org_id, -999))
1783: and hca.party_id = hp.party_id

Line 1814: -- Changed to use hz_cust_accounts, hz_parties, hz_cust_site_uses_all,

1810:
1811: /*---------------------------------------------------------------+
1812: | Update ship to customer name
1813: +---------------------------------------------------------------*/
1814: -- Changed to use hz_cust_accounts, hz_parties, hz_cust_site_uses_all,
1815: -- hz_cust_acct_sites_all as part of Uptake for R12
1816:
1817: l_stmt_id := 180;
1818:

Line 1824: , hz_cust_site_uses_all hsu

1820: SET ship_to_customer_name =
1821: (SELECT hp.party_name
1822: FROM hz_cust_accounts hca
1823: , hz_parties hp
1824: , hz_cust_site_uses_all hsu
1825: , hz_cust_acct_sites_all ha
1826: WHERE
1827: NVL(ha.org_id, -999) = NVL(l_ou_id,NVL(ha.org_id, -999))
1828: and hca.party_id = hp.party_id

Line 1936: -- Changed to use hz_cust_accounts, hz_parties, hz_cust_site_uses_all,

1932:
1933: /*---------------------------------------------------------------+
1934: | Update Country level of Geography dimension
1935: +---------------------------------------------------------------*/
1936: -- Changed to use hz_cust_accounts, hz_parties, hz_cust_site_uses_all,
1937: -- hz_cust_acct_sites_all as part of Uptake for R12
1938:
1939: l_stmt_id := 184;
1940:

Line 1945: ,hz_cust_site_uses_all hcsu

1941: update CST_BIS_MARGIN_SUMMARY cmt
1942: set COUNTRY_CODE =
1943: (select hl.country
1944: from hz_locations hl
1945: ,hz_cust_site_uses_all hcsu
1946: ,hz_cust_acct_sites_all hcas
1947: ,hz_party_sites hp
1948: where
1949: hcsu.org_id = cmt.org_id