APPS.OE_ID_TO_VALUE dependencies on HZ_CUST_ACCT_SITES

Line 5598: HZ_CUST_ACCT_SITES cas,

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
5602: AND cust.cust_account_id=cas.cust_account_id

Line 5661: HZ_CUST_ACCT_SITES cas,

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
5665: AND cust.cust_account_id=cas.cust_account_id

Line 6115: HZ_CUST_ACCT_SITES ACCT_SITE

6111: FROM
6112: HZ_CUST_SITE_USES_All SITE,
6113: HZ_PARTY_SITES PARTY_SITE,
6114: HZ_LOCATIONS LOC,
6115: HZ_CUST_ACCT_SITES ACCT_SITE
6116: WHERE
6117: SITE.SITE_USE_CODE = 'SOLD_TO'
6118: AND SITE.SITE_USE_ID = p_sold_to_site_use_id
6119: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 6540: hz_cust_acct_sites acct_site

6536: FROM
6537: hz_locations loc,
6538: hz_party_sites site,
6539: hz_cust_site_uses_all site_use,
6540: hz_cust_acct_sites acct_site
6541: WHERE
6542: site_use.site_use_id= p_end_customer_site_use_id
6543: and site_use.cust_acct_site_id=acct_site.cust_acct_site_id
6544: and acct_site.party_site_id=site.party_site_id