APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 85: ,okc_k_party_roles_b cplb

81: ,kpl.attribute13
82: ,kpl.attribute14
83: ,kpl.attribute15
84: FROM okl_k_party_roles kpl
85: ,okc_k_party_roles_b cplb
86: WHERE cplb.chr_id = l_khr_id
87: AND cplb.dnz_chr_id = cplb.chr_id
88: AND kpl.id = cplb.id
89: AND cplb.rle_code = 'LESSEE';

Line 154: FROM okc_k_party_roles_b cust_party_roles

150: IS
151: SELECT cust_party.party_name
152: ,cust_party.party_id
153: ,cust_accounts.account_number
154: FROM okc_k_party_roles_b cust_party_roles
155: ,hz_parties cust_party
156: ,hz_cust_accounts cust_accounts
157: WHERE cust_party.party_type in ( 'PERSON','ORGANIZATION')
158: AND cust_party.party_id = cust_party_roles.object1_id1

Line 298: ,okc_k_party_roles_b pty

294: SELECT pov.vendor_id
295: ,pov.vendor_name
296: FROM okc_k_lines_b cleb_vendor
297: ,po_vendors pov
298: ,okc_k_party_roles_b pty
299: WHERE cleb_vendor.cle_id = p_kle_id
300: AND cleb_vendor.dnz_chr_id = p_khr_id
301: AND cleb_vendor.lse_id = 34
302: AND pty.cle_id = cleb_vendor.id

Line 618: ,okc_k_party_roles_b role

614: ,party.vendor_name subsidy_party_name
615: ,party.vendor_id subsidy_vendor_id
616: FROM okl_subsidies_b sub
617: ,okl_k_lines subsidy_line
618: ,okc_k_party_roles_b role
619: ,po_vendors party
620: WHERE sub.id = subsidy_line.subsidy_id
621: AND role.cle_id = subsidy_line.id
622: AND role.object1_id1 = party.vendor_id