DBA Data[Home] [Help]

APPS.OKC_CFG_PUB dependencies on OKC_K_ITEMS

Line 97: okc_k_items_v cimv

93: AND czdv.config_rev_nbr = l_config_rev_nbr
94: AND NOT EXISTS (
95: SELECT 'x'
96: FROM okc_k_lines_v clev,
97: okc_k_items_v cimv
98: WHERE clev.id = cimv.cle_id
99: AND clev.dnz_chr_id = l_dnz_chr_id
100: AND clev.config_header_id = czdv.config_hdr_id
101: AND clev.config_revision_number = czdv.config_rev_nbr

Line 142: okc_k_items cim

138: cleb.price_list_id price_list_id,
139: cleb.dnz_chr_id dnz_chr_id,
140: cleb.pricing_date pricing_date -- Added for Bug 2393302
141: FROM okc_k_lines_b cleb,
142: okc_k_items cim
143: WHERE cleb.dnz_chr_id = l_dnz_chr_id
144: AND cleb.config_header_id = l_config_hdr_id
145: AND cleb.config_revision_number = l_config_rev_nbr
146: AND cleb.id = cim.cle_id