DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2723: , hz_cust_acct_sites_all casa

2719:
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

Line 2761: FROM hz_cust_acct_sites_all casa

2757: FROM GMD_ORG_ACCESS_VW;
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