APPS.GMD_SAMPLES_GRP dependencies on HZ_CUST_SITE_USES_ALL

Line 3728: hz_cust_site_uses_all s,

3724:
3725: CURSOR c_ship_to IS
3726: SELECT 1
3727: FROM hz_cust_acct_sites_all a,
3728: hz_cust_site_uses_all s,
3729: hz_cust_accounts_all c
3730: WHERE a.cust_acct_site_id = s.cust_acct_site_id
3731: AND a.org_id = s.org_id
3732: AND a.cust_account_id = c.cust_account_id

Line 5898: FROM hz_cust_site_uses_all

5894: AND OTL.LANGUAGE = userenv('LANG');
5895:
5896: CURSOR Cur_ship_to IS
5897: SELECT location
5898: FROM hz_cust_site_uses_all
5899: WHERE site_use_id = p_ship_to_site_id;
5900:
5901: CURSOR Cur_order_number IS
5902: SELECT h.order_number,