APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_K_ITEMS

Line 1843: OKC_K_ITEMS CIM_FA,

1839: WHERE oli.contract_number_old = p_contract_number
1840: AND EXISTS ( SELECT fa.asset_id
1841: FROM FA_ADDITIONS_B FA,
1842: OKL_ASSET_RETURNS_B OAR,
1843: OKC_K_ITEMS CIM_FA,
1844: OKC_K_LINES_B CLEB_FA,
1845: OKC_K_LINES_B CLEB_TL,
1846: OKC_K_HEADERS_B CHRB
1847: WHERE cleb_tl.chr_id = chrb.id

Line 1864: okc_k_items cim_2

1860: FROM okc_k_headers_b chrb_2,
1861: okc_statuses_b chr_sts,
1862: okc_k_lines_b cleb_2,
1863: okc_statuses_b cle_sts,
1864: okc_k_items cim_2
1865: WHERE chrb_2.id = cleb_2.dnz_chr_id
1866: AND chrb_2.scs_code in ('LEASE','LOAN')
1867: AND chrb_2.sts_code = chr_sts.code
1868: AND chr_sts.ste_code not in ('HOLD', 'EXPIRED', 'TERMINATED', 'CANCELLED')

Line 1889: OKC_K_ITEMS CIM_FA,

1885: WHERE oli.contract_number_old = p_contract_number
1886: AND NOT EXISTS (SELECT fa.asset_id
1887: FROM FA_ADDITIONS_B FA,
1888: OKL_ASSET_RETURNS_B OAR,
1889: OKC_K_ITEMS CIM_FA,
1890: OKC_K_LINES_B CLEB_FA,
1891: OKC_K_LINES_B CLEB_TL,
1892: OKC_K_HEADERS_B CHRB
1893: WHERE cleb_tl.chr_id = chrb.id

Line 23542: FROM okc_k_items_v item,

23538: l_proc_name VARCHAR2(35) := 'VALIDATE_USAGE_ITEM_ASSOC';
23539: CURSOR assoc_csr (p_usage_item_id NUMBER,
23540: p_asset_line_id NUMBER) IS
23541: SELECT 'Y'
23542: FROM okc_k_items_v item,
23543: okl_k_lines_full_v model,
23544: okc_line_styles_v style,
23545: cs_counters cc,
23546: cs_ctr_associations assoc