DBA Data[Home] [Help]

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 153: OKC_K_ITEMS ITEMS, OKL_CNTR_LVLNG_LNS_V CNTR, okc_k_lines_v cov_asset

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