APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_K_ITEMS

Line 1848: OKC_K_ITEMS CIM_FA,

1844: WHERE oli.contract_number_old = p_contract_number
1845: AND EXISTS ( SELECT fa.asset_id
1846: FROM FA_ADDITIONS_B FA,
1847: OKL_ASSET_RETURNS_B OAR,
1848: OKC_K_ITEMS CIM_FA,
1849: OKC_K_LINES_B CLEB_FA,
1850: OKC_K_LINES_B CLEB_TL,
1851: OKC_K_HEADERS_B CHRB
1852: WHERE cleb_tl.chr_id = chrb.id

Line 1870: okc_k_items cim_2

1866: FROM okc_k_headers_b chrb_2,
1867: okc_statuses_b chr_sts,
1868: okc_k_lines_b cleb_2,
1869: okc_statuses_b cle_sts,
1870: okc_k_items cim_2
1871: WHERE chrb_2.id = cleb_2.dnz_chr_id
1872: AND chrb_2.scs_code in ('LEASE','LOAN')
1873: AND chrb_2.sts_code = chr_sts.code
1874: AND chr_sts.ste_code not in ('HOLD', 'EXPIRED', 'TERMINATED', 'CANCELLED')

Line 1895: OKC_K_ITEMS CIM_FA,

1891: WHERE oli.contract_number_old = p_contract_number
1892: AND NOT EXISTS (SELECT fa.asset_id
1893: FROM FA_ADDITIONS_B FA,
1894: OKL_ASSET_RETURNS_B OAR,
1895: OKC_K_ITEMS CIM_FA,
1896: OKC_K_LINES_B CLEB_FA,
1897: OKC_K_LINES_B CLEB_TL,
1898: OKC_K_HEADERS_B CHRB
1899: WHERE cleb_tl.chr_id = chrb.id

Line 23731: FROM okc_k_items_v item,

23727: l_proc_name VARCHAR2(35) := 'VALIDATE_USAGE_ITEM_ASSOC';
23728: CURSOR assoc_csr (p_usage_item_id NUMBER,
23729: p_asset_line_id NUMBER) IS
23730: SELECT 'Y'
23731: FROM okc_k_items_v item,
23732: okl_k_lines_full_v model,
23733: okc_line_styles_v style,
23734: cs_counters cc,
23735: cs_ctr_associations assoc