[Home] [Help]
137: AND per.person_id = fu.employee_id;
138:
139: CURSOR doc_type_name_csr IS
140: SELECT name
141: FROM okc_bus_doc_types_tl
142: WHERE document_type = p_doc_type
143: AND language = userenv('LANG');
144:
145: CURSOR doc_type_name_lkp_csr IS
176: FROM jtf_rs_groups_tl
177: WHERE group_id = p_sales_group_id
178: AND language = userenv('LANG');
179:
180: l_doc_type_name okc_bus_doc_types_tl.name%TYPE;
181: l_cust_name hz_parties.party_name%TYPE;
182: l_ou_name hr_all_organization_units.name%TYPE;
183: l_salesperson_name jtf_rs_salesreps.name%TYPE;
184: l_trans_type_name oe_transaction_types_tl.name%TYPE;
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
426: AND header.sold_to_org_id = hzc.cust_account_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
456: AND header.sold_to_org_id = hzc.cust_account_id (+)
477: t.contract_admin_id AS contract_admin_id
478: FROM aso_quote_headers header,
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
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
518: FROM okc_rep_contract_parties con_parties
519: WHERE header.contract_id = con_parties.contract_id