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 292: --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

288: l_ret varchar2(240);
289: BEGIN
290: if p_loc_id is null then return 'Other'; end if;
291:
292: --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
293: select substrb(hp.PARTY_NAME,1,50) || '-' || csu.location
294: into l_ret
295: from HZ_CUST_SITE_USES_ALL csu,
296: HZ_CUST_ACCOUNTS ca,

Line 297: HZ_PARTIES hp,

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