APPS.GMD_SAMPLES_GRP dependencies on HZ_CUST_SITE_USES_ALL

Line 3133: hz_cust_site_uses_all s,

3129:
3130: CURSOR c_ship_to IS
3131: SELECT 1
3132: FROM hz_cust_acct_sites_all a,
3133: hz_cust_site_uses_all s,
3134: hz_cust_accounts_all c
3135: WHERE a.cust_acct_site_id = s.cust_acct_site_id
3136: AND a.org_id = s.org_id
3137: AND a.cust_account_id = c.cust_account_id

Line 5230: FROM hz_cust_site_uses_all

5226: AND OTL.LANGUAGE = userenv('LANG');
5227:
5228: CURSOR Cur_ship_to IS
5229: SELECT location
5230: FROM hz_cust_site_uses_all
5231: WHERE site_use_id = p_ship_to_site_id;
5232:
5233: CURSOR Cur_order_number IS
5234: SELECT h.order_number,