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
426: AND header.sold_to_org_id = hzc.cust_account_id (+)
427: AND hzc.party_id = customer.party_id (+)
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
456: AND header.sold_to_org_id = hzc.cust_account_id (+)
457: AND hzc.party_id = customer.party_id (+)
479: okc_template_usages t,
480: hz_parties customer,
481: okc_bus_doc_types_tl doc_type,
482: aso_quote_statuses_vl quote_status,
483: hr_all_organization_units_tl hr
484: WHERE t.document_type = 'QUOTE'
485: AND header.quote_header_id = t.document_id
486: AND header.max_version_flag = 'Y'
487: AND (p_cust_id IS NULL OR header.cust_party_id = p_cust_id)
509: doc_type_tl.name AS document_type,
510: hr.name AS operating_unit,
511: header.owner_id AS contract_admin_id
512: FROM okc_rep_contracts header,
513: Hr_all_organization_units_tl hr,
514: Okc_bus_doc_types_b doc_type_b,
515: Okc_bus_doc_types_tl doc_type_tl
516: WHERE (p_cust_id IS NULL OR EXISTS (
517: SELECT con_parties.party_id