DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKC_K_ITEMS

Line 186: from okc_k_items cim,

182: ---------------------------------------------------------------------------
183: cursor l_addon_modfn_csr (p_rbk_chr_id in NUMBER,
184: p_orig_chr_id in NUMBER) is
185: select clet.name
186: from okc_k_items cim,
187: okc_line_styles_b addon_lseb,
188: okc_k_lines_b addon_cleb,
189: okc_line_styles_b model_lseb,
190: okc_k_lines_b model_cleb,

Line 215: from okc_k_items cim2,

211: and lseb.lty_code = 'FREE_FORM1'
212: --to avoid picking up new asset added during rebook
213: and cleb.orig_system_id1 is not null
214: and exists (select '1'
215: from okc_k_items cim2,
216: okc_k_lines_b addon_cleb2,
217: okc_k_lines_b model_cleb2,
218: okc_k_lines_b cleb2
219: where cim2.cle_id = addon_cleb2.id

Line 894: OKC_K_ITEMS cim_orig,

890: asr.id asset_return_id
891: FROM OKL_ASSET_RETURNS_B asr,
892: OKC_K_LINES_B cle_orig,
893: OKC_LINE_STYLES_B lse_orig,
894: OKC_K_ITEMS cim_orig,
895: OKC_K_ITEMS cim,
896: OKC_K_LINES_B cle,
897: OKC_LINE_STYLES_B lse,
898: OKC_STATUSES_B sts,

Line 895: OKC_K_ITEMS cim,

891: FROM OKL_ASSET_RETURNS_B asr,
892: OKC_K_LINES_B cle_orig,
893: OKC_LINE_STYLES_B lse_orig,
894: OKC_K_ITEMS cim_orig,
895: OKC_K_ITEMS cim,
896: OKC_K_LINES_B cle,
897: OKC_LINE_STYLES_B lse,
898: OKC_STATUSES_B sts,
899: OKL_TXL_ASSETS_B txl