APPS.OKL_UBB_PVT dependencies on OKC_K_ITEMS

Line 112: okc_k_items cim_ib,

108: select cle_inst.cle_id financial_asset_id
109: from
110: okc_k_lines_b cle_inst,
111: okc_k_lines_b cle_ib,
112: okc_k_items cim_ib,
113: csi_item_instances cii,
114: cs_csi_counter_groups ccg,
115: csi_counters_vl cc,
116: okc_k_items cim,

Line 116: okc_k_items cim,

112: okc_k_items cim_ib,
113: csi_item_instances cii,
114: cs_csi_counter_groups ccg,
115: csi_counters_vl cc,
116: okc_k_items cim,
117: okc_k_lines_b cleb,
118: okc_line_styles_b lseb,
119: okc_k_headers_b chrb
120: where cle_ib.id = cim_ib.cle_id

Line 154: OKC_K_ITEMS ITEMS, OKL_CNTR_LVLNG_LNS_V CNTR, okc_k_lines_v cov_asset

150: OKS_LNS.AMOUNT ASSET_AMOUNT, OKS_LNS.ID OKS_DETAIL_ID,
151: chr.contract_number contract_number
152: from okc_k_rel_objs rel, okc_k_lines_v lns, oks_bill_cont_lines_v oks_cont,
153: OKS_BILL_SUB_LINES_V OKS_LNS, OKC_K_HEADERS_B chr,
154: OKC_K_ITEMS ITEMS, OKL_CNTR_LVLNG_LNS_V CNTR, okc_k_lines_v cov_asset
155: where rel.rty_code = 'OKLUBB'
156: and lns.chr_id = rel.object1_id1
157: and lns.id = cov_asset.cle_id
158: and lns.id = oks_cont.cle_id

Line 180: OKC_K_ITEMS ITEMS, OKL_CNTR_LVLNG_LNS_V CNTR, okc_k_lines_v cov_asset,

176: chr.contract_number contract_number,
177: iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE) bankruptcy_sts
178: from okc_k_rel_objs rel, okc_k_lines_v lns, oks_bill_cont_lines_v oks_cont,
179: OKS_BILL_SUB_LINES_V OKS_LNS, OKC_K_HEADERS_B chr,
180: OKC_K_ITEMS ITEMS, OKL_CNTR_LVLNG_LNS_V CNTR, okc_k_lines_v cov_asset,
181: hz_cust_accounts hca
182: where rel.rty_code = 'OKLUBB'
183: and chr.cust_acct_id = hca.cust_account_id
184: and hca.status = 'A'