233: orgu.organization_id org_id,
234: orgu.name org_name
235: from
236: hr_organization_information orgi,
237: hr_operating_units orgu
238: where orgi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
239: and orgi.organization_id = orgu.organization_id
240: ) org,
241: ( select
283: orgu.organization_id org_id,
284: orgu.name org_name
285: from
286: hr_organization_information orgi,
287: hr_operating_units orgu
288: where orgi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
289: and orgi.organization_id = orgu.organization_id
290: ) org,
291: ( select
389: orgu.organization_id org_id,
390: orgu.name org_name
391: from
392: hr_organization_information orgi,
393: hr_operating_units orgu
394: where orgi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
395: and orgi.organization_id = orgu.organization_id
396: ) org
397: where article_srch_id = p_search_id
468: orgu.organization_id org_id,
469: orgu.name org_name
470: from
471: hr_organization_information orgi,
472: hr_operating_units orgu
473: where orgi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
474: and orgi.organization_id = orgu.organization_id
475: ) org
476: where t.article_srch_id = p_search_id
496: orgu.organization_id org_id,
497: orgu.name org_name
498: from
499: hr_organization_information orgi,
500: hr_operating_units orgu
501: where orgi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
502: and orgi.organization_id = orgu.organization_id
503: ) org
504: where t.article_srch_id = p_search_id
582: orgu.organization_id org_id,
583: orgu.name org_name
584: from
585: hr_organization_information orgi,
586: hr_operating_units orgu
587: where orgi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
588: and orgi.organization_id = orgu.organization_id
589: ) org
590: where a.article_id = v.article_id