APPS.OE_ID_TO_VALUE dependencies on HZ_CUST_SITE_USES_ALL

Line 5597: FROM HZ_CUST_SITE_USES_all site,

5593: l_site_use_code := 'SHIP_TO';
5594:
5595: SELECT /* MOAC_SQL_CHANGE */ P.PARTY_NAME
5596: INTO x_ship_to_customer_name
5597: FROM HZ_CUST_SITE_USES_all site,
5598: HZ_CUST_ACCT_SITES cas,
5599: HZ_CUST_ACCOUNTS cust,
5600: HZ_PARTIES p
5601: WHERE site.cust_acct_site_id=cas.cust_acct_site_id

Line 5660: FROM HZ_CUST_SITE_USES_ALL site,

5656: l_site_use_code := 'BILL_TO';
5657:
5658: SELECT /* MOAC_SQL_CHANGE */ P.PARTY_NAME
5659: INTO x_invoice_to_customer_name
5660: FROM HZ_CUST_SITE_USES_ALL site,
5661: HZ_CUST_ACCT_SITES cas,
5662: HZ_CUST_ACCOUNTS cust,
5663: HZ_PARTIES p
5664: WHERE site.cust_acct_site_id=cas.cust_acct_site_id

Line 6138: HZ_CUST_SITE_USES_All SITE,

6134: , x_sold_to_location_postal
6135: , x_sold_to_location_country
6136:
6137: FROM
6138: HZ_CUST_SITE_USES_All SITE,
6139: HZ_PARTY_SITES PARTY_SITE,
6140: HZ_LOCATIONS LOC,
6141: HZ_CUST_ACCT_SITES ACCT_SITE
6142: WHERE

Line 6565: hz_cust_site_uses_all site_use,

6561: ,x_end_customer_country
6562: FROM
6563: hz_locations loc,
6564: hz_party_sites site,
6565: hz_cust_site_uses_all site_use,
6566: hz_cust_acct_sites acct_site
6567: WHERE
6568: site_use.site_use_id= p_end_customer_site_use_id
6569: and site_use.cust_acct_site_id=acct_site.cust_acct_site_id