eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKC_K_ITEMS_V

Line 973: okc_k_items_v cim,

969: SELECT SUM(cle.price_unit * cim.number_of_items) oec
970: FROM okc_subclass_top_line stl,
971: okc_line_styles_b lse2,
972: okc_line_styles_b lse1,
973: okc_k_items_v cim,
974: okc_k_lines_v cle
975: WHERE cle.cle_id = p_top_cle_id
976: AND cle.dnz_chr_id = p_dnz_chr_id
977: AND cle.id = cim.cle_id

Line 993: okc_k_items_v cim,

989: FROM okc_subclass_top_line stl,
990: okc_line_styles_b lse3,
991: okc_line_styles_b lse2,
992: okc_line_styles_b lse1,
993: okc_k_items_v cim,
994: okc_k_lines_b cle
995: WHERE cle.dnz_chr_id = p_dnz_chr_id
996: AND cle.dnz_chr_id = cim.dnz_chr_id
997: AND cle.id = cim.cle_id

Line 12692: okc_k_items_v itm,

12688: CURSOR get_asset_cost_csr (p_kle_id IN NUMBER) IS
12689: SELECT nvl(fab.cost,0) current_cost
12690: FROM fa_books fab,
12691: fa_book_controls fbc,
12692: okc_k_items_v itm,
12693: okc_k_lines_b kle,
12694: okc_line_styles_v lse
12695: WHERE fbc.book_class = 'CORPORATE'
12696: AND fab.book_type_code = fbc.book_type_code

Line 14391: okc_k_items_v cim,

14387: SELECT SUM(cle.price_unit * cim.number_of_items) asset_cost
14388: FROM okc_subclass_top_line stl,
14389: okc_line_styles_b lse2,
14390: okc_line_styles_b lse1,
14391: okc_k_items_v cim,
14392: okc_k_lines_v cle
14393: WHERE cle.cle_id = p_line_id
14394: AND cle.dnz_chr_id = p_dnz_chr_id
14395: AND cle.id = cim.cle_id

Line 14412: okc_k_items_v cim,

14408: FROM okc_subclass_top_line stl,
14409: okc_line_styles_b lse3,
14410: okc_line_styles_b lse2,
14411: okc_line_styles_b lse1,
14412: okc_k_items_v cim,
14413: okc_k_lines_b cle
14414: WHERE cle.dnz_chr_id = p_dnz_chr_id
14415: AND cle.dnz_chr_id = cim.dnz_chr_id
14416: AND cle.id = cim.cle_id

Line 14697: okc_k_items_v cim,

14693: FROM okc_subclass_top_line stl,
14694: okc_line_styles_b lse3,
14695: okc_line_styles_b lse2,
14696: okc_line_styles_b lse1,
14697: okc_k_items_v cim,
14698: okc_k_lines_b cle
14699: WHERE cle.dnz_chr_id = p_contract_id
14700: AND cle.dnz_chr_id = cim.dnz_chr_id
14701: AND cle.id = cim.cle_id