APPS.OE_ID_TO_VALUE dependencies on HZ_CUST_ACCOUNTS

Line 1842: FROM HZ_CUST_ACCOUNTS C

1838: INTO x_org
1839: , x_customer_number
1840: , x_account_description
1841: , x_registry_id
1842: FROM HZ_CUST_ACCOUNTS C
1843: , HZ_PARTIES P
1844: WHERE C.CUST_ACCOUNT_ID = p_sold_to_org_id
1845: AND C.PARTY_ID =P.PARTY_ID;
1846:

Line 5599: HZ_CUST_ACCOUNTS cust,

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
5603: AND cust.party_id = p.party_id

Line 5662: HZ_CUST_ACCOUNTS cust,

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
5666: AND cust.party_id = p.party_id

Line 6219: HZ_CUST_ACCOUNTS CUST_ACCT,

6215: x_email_address
6216: FROM HZ_CONTACT_POINTS CONTACT,
6217: HZ_PARTIES CONTACT_PARTY,
6218: HZ_CUST_ACCOUNT_ROLES ACCT_ROLES,
6219: HZ_CUST_ACCOUNTS CUST_ACCT,
6220: HZ_RELATIONSHIPS PARTY_REL,
6221: HZ_PARTIES REL_PARTY,
6222: AR_LOOKUPS ARL
6223: WHERE CONTACT.owner_table_name(+) = 'HZ_PARTIES'