APPS.OE_OE_FORM_HEADER dependencies on HZ_CUST_SITE_USES_ALL

Line 2353: FROM HZ_CUST_SITE_USES_ALL site,

2349: x_header_val_rec.deliver_to_address3,
2350: x_header_val_rec.deliver_to_address4,
2351: x_header_val_rec.deliver_to_address5
2352:
2353: FROM HZ_CUST_SITE_USES_ALL site,
2354: HZ_CUST_ACCT_SITES_ALL cas,
2355: hz_cust_accounts cust,
2356: hz_parties party,
2357: hz_party_sites ps,

Line 2773: FROM HZ_CUST_SITE_USES_ALL site,

2769: l_site_use_code := 'BILL_TO';
2770:
2771: SELECT /* MOAC_SQL_CHANGE */ cas.cust_account_id
2772: INTO x_invoice_to_customer_id
2773: FROM HZ_CUST_SITE_USES_ALL site,
2774: HZ_CUST_ACCT_SITES_ALL cas
2775: WHERE site.cust_acct_site_id = cas.cust_acct_site_id
2776: AND site.site_use_code=l_site_use_code
2777: AND site.site_use_id=p_site_use_id;

Line 2801: FROM HZ_CUST_SITE_USES_ALL site,

2797: l_site_use_code := 'SHIP_TO';
2798:
2799: SELECT /* MOAC_SQL_CHANGE */ cas.cust_account_id
2800: INTO x_ship_to_customer_id
2801: FROM HZ_CUST_SITE_USES_ALL site,
2802: HZ_CUST_ACCT_SITES_ALL cas
2803: WHERE site.cust_acct_site_id = cas.cust_acct_site_id
2804: AND site.site_use_code=l_site_use_code
2805: AND site.site_use_id=p_site_use_id;

Line 3397: hz_cust_site_uses_all site,

3393: INTO x_customer_id,
3394: x_customer_name,
3395: x_customer_number
3396: from
3397: hz_cust_site_uses_all site,
3398: hz_cust_acct_sites_all cas,
3399: hz_cust_accounts cust,
3400: hz_parties party
3401: where site.site_use_code = p_site_use_code