APPS.MSD_SR_UTIL dependencies on HZ_CUST_ACCOUNTS

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 296: HZ_CUST_ACCOUNTS ca,

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,
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

Line 1076: --Bug 4585376 RA_CUSTOMERS replaced by HZ_CUST_ACCOUNTS

1072: where wip_entity_id = p_txn_source_id
1073: order by repair_job_xref_id desc;
1074:
1075: cursor c2 (p_repair_line_id in number) is
1076: --Bug 4585376 RA_CUSTOMERS replaced by HZ_CUST_ACCOUNTS
1077: select decode(decode(nvl(lower(p_cust_filter), '1'), '1', '1', 'attribute1',
1078: cust.attribute1, 'attribute2', cust.attribute2, 'attribute3', cust.attribute3,
1079: 'attribute4', cust.attribute4, 'attribute5', cust.attribute5, 'attribute6',
1080: cust.attribute6, 'attribute7', cust.attribute7, 'attribute8', cust.attribute8,

Line 1086: hz_cust_accounts cust,

1082: cust.attribute11, 'attribute12', cust.attribute12, 'attribute13',cust.attribute13,
1083: 'attribute14', cust.attribute14, 'attribute15', cust.attribute15, '2'), '1',
1084: nvl(cia.account_id, msd_sr_util.get_null_pk), msd_sr_util.get_null_pk)
1085: from cs_incidents_all_b cia,
1086: hz_cust_accounts cust,
1087: csd_repairs crp
1088: where crp.repair_line_id = p_repair_line_id
1089: and cia.incident_id = crp.incident_id
1090: and cust.cust_account_id = cia.account_id;

Line 1213: --Bug 4585376 RA_CUSTOMERS replaced by HZ_CUST_ACCOUNTS

1209: x_customer_id number ;
1210:
1211:
1212: cursor c_customer_id is
1213: --Bug 4585376 RA_CUSTOMERS replaced by HZ_CUST_ACCOUNTS
1214: select decode( decode(nvl(lower(filtercust.parameter_value), '1'), '1', '1',
1215: 'attribute1', cust.attribute1,
1216: 'attribute2', cust.attribute2,
1217: 'attribute3', cust.attribute3,

Line 1232: hz_cust_accounts cust,

1228: 'attribute14', cust.attribute14,
1229: 'attribute15', cust.attribute15, '2')
1230: , '1', nvl(cust.cust_account_id,msd_sr_util.get_null_pk), msd_sr_util.get_null_pk)
1231: from
1232: hz_cust_accounts cust,
1233: (select parameter_value from msd_setup_parameters where parameter_name = 'MSD_CUSTOMER_ATTRIBUTE') filtercust
1234: where cust.party_id = p_party_id
1235: order by cust.cust_account_id ASC;
1236: