APPS.OE_OE_FORM_HEADER dependencies on HZ_CUST_SITE_USES_ALL

Line 2354: FROM HZ_CUST_SITE_USES_ALL site,

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

Line 2774: FROM HZ_CUST_SITE_USES_ALL site,

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

Line 2802: FROM HZ_CUST_SITE_USES_ALL site,

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

Line 3400: hz_cust_site_uses_all site,

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