DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on HZ_CUST_ACCOUNTS_ALL

Line 1938: , hz_cust_accounts_all hzca

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
1941: AND casa.cust_account_id = hzca.cust_account_id
1942: AND casa.org_id = csua.org_id

Line 1952: , hz_cust_accounts_all caa

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
1956: AND csua.site_use_code = 'SHIP_TO'