DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2065: , hz_cust_acct_sites_all casa

2061:
2062: CURSOR c_cust IS
2063: SELECT csua.org_id
2064: FROM hr_operating_units ou
2065: , hz_cust_acct_sites_all casa
2066: , hz_cust_site_uses_all csua
2067: , hz_parties hzp
2068: , hz_cust_accounts_all hzca
2069: WHERE ou.organization_id = csua.org_id

Line 2080: FROM hz_cust_acct_sites_all casa

2076:
2077:
2078: CURSOR c_ship_to IS
2079: SELECT 1
2080: FROM hz_cust_acct_sites_all casa
2081: , hz_cust_site_uses_all csua
2082: , hz_cust_accounts_all caa
2083: WHERE casa.cust_acct_site_id = csua.cust_acct_site_id
2084: AND casa.org_id = csua.org_id