DBA Data[Home] [Help]

APPS.OKL_CREDIT_MEMO_PVT dependencies on OKC_K_ITEMS

Line 34: , okc_k_items item

30: UNION
31: SELECT cs.cust_acct_site_id --, cp.standard_terms payment_term_id
32: FROM okc_k_headers_b khr
33: , okc_k_lines_b cle
34: , okc_k_items item
35: , okc_k_lines_b linked_asset
36: , okx_cust_site_uses_v cs
37: , hz_customer_profiles cp
38: WHERE khr.id = p_khr_id

Line 154: EXISTS ( SELECT 'x' FROM okc_k_items cim

150: 'SYNDICATION'
151: FROM
152: okc_k_headers_b chr
153: WHERE
154: EXISTS ( SELECT 'x' FROM okc_k_items cim
155: WHERE cim.object1_id1 = to_char(chr.id) AND
156: EXISTS ( SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
157: WHERE cle.lse_id = lse.id AND
158: lse.lty_code = 'SHARED' AND cle.id = cim.cle_id ) AND