DBA Data[Home] [Help]

APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on PO_VENDORS

Line 297: ,po_vendors pov

293: IS
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

Line 619: ,po_vendors party

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
623: AND subsidy_line.id = p_kle_id;