DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on HZ_CUST_SITE_USES_ALL

Line 2873: , hz_cust_site_uses_all csua

2869: CURSOR c_cust IS
2870: SELECT 1
2871: FROM hr_operating_units ou
2872: , hz_cust_acct_sites_all casa
2873: , hz_cust_site_uses_all csua
2874: , hz_parties hzp
2875: , hz_cust_accounts_all hzca
2876: WHERE ou.organization_id = csua.org_id
2877: AND casa.cust_acct_site_id = csua.cust_acct_site_id

Line 2911: , hz_cust_site_uses_all csua

2907:
2908: CURSOR c_ship_to IS
2909: SELECT 1
2910: FROM hz_cust_acct_sites_all casa
2911: , hz_cust_site_uses_all csua
2912: , hz_cust_accounts_all caa
2913: WHERE casa.cust_acct_site_id = csua.cust_acct_site_id
2914: AND casa.org_id = csua.org_id
2915: AND casa.cust_account_id = caa.cust_account_id