DBA Data[Home] [Help]

APPS.OKL_AM_CREATE_QUOTE_PVT dependencies on HZ_PARTIES

Line 212: hz_parties hp,

208: stl.meaning sts_meaning,
209: chr.authoring_org_id org_id,
210: hp.party_name party_name
211: FROM okc_statuses_tl stl,
212: hz_parties hp,
213: okc_k_party_roles_b cpl,
214: okc_k_headers_b chr
215: -- BAKUCHIB 2781134 start
216: WHERE upper(chr.contract_number) LIKE upper(nvl(p_achr_rec.contract_number,chr.contract_number))

Line 254: hz_parties hp,

250: stl.meaning sts_meaning,
251: chr.authoring_org_id org_id,
252: hp.party_name party_name
253: FROM okc_statuses_tl stl,
254: hz_parties hp,
255: okc_k_party_roles_b cpl,
256: okc_k_headers_b chr
257: -- BAKUCHIB 2781134 start
258: WHERE upper(chr.contract_number) LIKE upper(nvl(p_achr_rec.contract_number,chr.contract_number))

Line 318: hz_parties hp,

314: stl.meaning sts_meaning,
315: chr.authoring_org_id org_id,
316: hp.party_name party_name
317: FROM okc_statuses_tl stl,
318: hz_parties hp,
319: okc_k_party_roles_b cpl,
320: okc_k_headers_b chr
321: -- BAKUCHIB 2781134 start
322: WHERE upper(chr.contract_number) LIKE upper(nvl(p_achr_rec.contract_number,chr.contract_number))

Line 384: hz_parties hp,

380: stl.meaning sts_meaning,
381: chr.authoring_org_id org_id,
382: hp.party_name party_name
383: FROM okc_statuses_tl stl,
384: hz_parties hp,
385: okc_k_party_roles_b cpl,
386: okc_k_headers_b chr
387: -- BAKUCHIB 2781134 start
388: WHERE upper(chr.contract_number) LIKE upper(nvl(p_achr_rec.contract_number,chr.contract_number))