APPS.MSD_SR_UTIL dependencies on HZ_PARTIES

Line 97: --Bug 4585376 - RA_CUSTOMERS replaced by HZ_PARTIES and HZ_CUST_ACCOUNTS

93: l_cust varchar2(50);
94: BEGIN
95: if p_cust_id is NULL then return 'Other'; end if;
96:
97: --Bug 4585376 - RA_CUSTOMERS replaced by HZ_PARTIES and HZ_CUST_ACCOUNTS
98: select substrb(PARTY.PARTY_NAME,1,50) customer_name
99: into l_cust
100: from HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT
101: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID

Line 100: from HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT

96:
97: --Bug 4585376 - RA_CUSTOMERS replaced by HZ_PARTIES and HZ_CUST_ACCOUNTS
98: select substrb(PARTY.PARTY_NAME,1,50) customer_name
99: into l_cust
100: from HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT
101: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
102: and CUST_ACCT.CUST_ACCOUNT_ID = p_cust_id;
103:
104: return l_cust;

Line 291: --Bug 4585376 RA_CUSTOMERS, RA_ADDRESSES_ALL and RA_SITE_USES_ALL replaced by HZ_CUST_SITE_USES_ALL, HZ_CUST_ACCOUNTS, HZ_PARTIES and HZ_CUST_ACCT_SITES_ALL

287: l_ret varchar2(240);
288: BEGIN
289: if p_loc_id is null then return 'Other'; end if;
290:
291: --Bug 4585376 RA_CUSTOMERS, RA_ADDRESSES_ALL and RA_SITE_USES_ALL replaced by HZ_CUST_SITE_USES_ALL, HZ_CUST_ACCOUNTS, HZ_PARTIES and HZ_CUST_ACCT_SITES_ALL
292: select substrb(hp.PARTY_NAME,1,50) || '-' || csu.location
293: into l_ret
294: from HZ_CUST_SITE_USES_ALL csu,
295: HZ_CUST_ACCOUNTS ca,

Line 296: HZ_PARTIES hp,

292: select substrb(hp.PARTY_NAME,1,50) || '-' || csu.location
293: into l_ret
294: from HZ_CUST_SITE_USES_ALL csu,
295: HZ_CUST_ACCOUNTS ca,
296: HZ_PARTIES hp,
297: HZ_CUST_ACCT_SITES_ALL cas
298: where csu.site_use_id = p_loc_id
299: and csu.cust_acct_site_id = cas.cust_acct_site_id
300: and cas.cust_account_id = ca.cust_account_id