DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 1936: , hz_cust_site_uses_all csua

1932: CURSOR c_cust IS
1933: SELECT csua.org_id
1934: FROM hr_operating_units ou
1935: , hz_cust_acct_sites_all casa
1936: , hz_cust_site_uses_all csua
1937: , hz_parties hzp
1938: , hz_cust_accounts_all hzca
1939: WHERE ou.organization_id = csua.org_id
1940: AND casa.cust_acct_site_id = csua.cust_acct_site_id

Line 1951: , hz_cust_site_uses_all csua

1947:
1948: CURSOR c_ship_to IS
1949: SELECT 1
1950: FROM hz_cust_acct_sites_all casa
1951: , hz_cust_site_uses_all csua
1952: , hz_cust_accounts_all caa
1953: WHERE casa.cust_acct_site_id = csua.cust_acct_site_id
1954: AND casa.org_id = csua.org_id
1955: AND casa.cust_account_id = caa.cust_account_id