APPS.CSTPOMLD dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1770: -- hz_cust_acct_sites_all as part of Uptake for R12

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:
1774: UPDATE CST_BIS_MARGIN_SUMMARY temp

Line 1780: , hz_cust_acct_sites_all ha

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
1784: and NVL(hsu.org_id, -999) = NVL(l_ou_id, NVL(hsu.org_id, -999))

Line 1815: -- hz_cust_acct_sites_all as part of Uptake for R12

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:
1819: UPDATE CST_BIS_MARGIN_SUMMARY temp

Line 1825: , hz_cust_acct_sites_all ha

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
1829: and NVL(hsu.org_id, -999) = NVL(l_ou_id, NVL(hsu.org_id, -999))

Line 1937: -- hz_cust_acct_sites_all as part of Uptake for R12

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:
1941: update CST_BIS_MARGIN_SUMMARY cmt

Line 1946: ,hz_cust_acct_sites_all hcas

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
1950: and hcsu.site_use_id = cmt.ship_to_site_use_id