APPS.OKC_CREATE_PO_FROM_K_PVT dependencies on OKC_CONTACTS

Line 188: vendor_contact_id okc_contacts.object1_id1%type,

184: rate okc_conversion_attribs_v.conversion_rate%type,
185: agent_id okx_buyers_v.id1%type,
186: vendor_id okx_vendors_v.id1%type,
187: vendor_site_id okx_vendor_sites_v.id1%type,
188: vendor_contact_id okc_contacts.object1_id1%type,
189: ship_to_location_id okc_rules_b.object1_id1%type,
190: bill_to_location_id okc_rules_b.object1_id1%type,
191: terms_id okc_rules_b.object1_id1%type,
192: freight_terms okc_rules_b.object1_id1%type,

Line 450: FROM okc_contacts cco

446: SELECT user_name
447: INTO l_k_buyer_name
448: FROM FND_USER
449: WHERE EMPLOYEE_ID = (SELECT cco.object1_id1 agent_id
450: FROM okc_contacts cco
451: WHERE cco.cro_code = 'BUYER'
452: AND cco.jtot_object1_code = 'OKX_BUYER'
453: AND cco.dnz_chr_id = p_chr_id
454: AND rownum = 1)

Line 990: FROM okc_contacts cco

986: BEGIN
987:
988: SELECT cco.object1_id1 agent_id
989: INTO x_po_header_rec.agent_id
990: FROM okc_contacts cco
991: WHERE cco.cro_code = 'BUYER'
992: AND cco.jtot_object1_code = 'OKX_BUYER'
993: AND cco.dnz_chr_id = p_chr_id
994: AND rownum = 1; -- added - just in case there is more than one contact defined

Line 1031: FROM okc_contacts cco

1027: BEGIN
1028:
1029: SELECT cco.object1_id1 vendor_contact_id
1030: INTO x_po_header_rec.vendor_contact_id
1031: FROM okc_contacts cco
1032: WHERE cco.cpl_id = l_cpr_id
1033: AND cco.dnz_chr_id = p_chr_id
1034: AND cco.jtot_object1_code = 'OKX_VCONTACT'
1035: AND rownum = 1; -- added - just in case there is more than one contact defined