DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on HZ_CUST_SITE_USES_ALL

Line 2724: , hz_cust_site_uses_all csua

2720: CURSOR c_cust IS
2721: SELECT 1
2722: FROM hr_operating_units ou
2723: , hz_cust_acct_sites_all casa
2724: , hz_cust_site_uses_all csua
2725: , hz_parties hzp
2726: , hz_cust_accounts_all hzca
2727: WHERE ou.organization_id = csua.org_id
2728: AND casa.cust_acct_site_id = csua.cust_acct_site_id

Line 2762: , hz_cust_site_uses_all csua

2758:
2759: CURSOR c_ship_to IS
2760: SELECT 1
2761: FROM hz_cust_acct_sites_all casa
2762: , hz_cust_site_uses_all csua
2763: , hz_cust_accounts_all caa
2764: WHERE casa.cust_acct_site_id = csua.cust_acct_site_id
2765: AND casa.org_id = csua.org_id
2766: AND casa.cust_account_id = caa.cust_account_id