417: t.contract_admin_id AS contract_admin_id
418: FROM oe_blanket_headers header,
419: okc_template_usages t,
420: hz_parties customer,
421: hz_cust_accounts hzc,
422: okc_bus_doc_types_tl doc_type,
423: hr_all_organization_units_tl hr
424: WHERE t.document_type = 'B'
425: AND header.header_id = t.document_id
447: t.contract_admin_id AS contract_admin_id
448: FROM oe_order_headers header,
449: okc_template_usages t,
450: hz_parties customer,
451: hz_cust_accounts hzc,
452: okc_bus_doc_types_tl doc_type,
453: hr_all_organization_units_tl hr
454: WHERE t.document_type = 'O'
455: AND header.header_id = t.document_id