DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 2066: , hz_cust_site_uses_all csua

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
2070: AND casa.cust_acct_site_id = csua.cust_acct_site_id

Line 2081: , hz_cust_site_uses_all csua

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
2085: AND casa.cust_account_id = caa.cust_account_id