DBA Data[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKC_K_ITEMS_V

Line 1118: okc_k_items_v cim,

1114: SELECT SUM(cle.price_unit * cim.number_of_items) oec
1115: FROM okc_subclass_top_line stl,
1116: okc_line_styles_b lse2,
1117: okc_line_styles_b lse1,
1118: okc_k_items_v cim,
1119: okc_k_lines_v cle
1120: WHERE cle.cle_id = p_top_cle_id
1121: AND cle.dnz_chr_id = p_dnz_chr_id
1122: AND cle.id = cim.cle_id

Line 1138: okc_k_items_v cim,

1134: FROM okc_subclass_top_line stl,
1135: okc_line_styles_b lse3,
1136: okc_line_styles_b lse2,
1137: okc_line_styles_b lse1,
1138: okc_k_items_v cim,
1139: okc_k_lines_b cle
1140: WHERE cle.dnz_chr_id = p_dnz_chr_id
1141: AND cle.dnz_chr_id = cim.dnz_chr_id
1142: AND cle.id = cim.cle_id

Line 1238: okc_k_items_v cim,

1234: SELECT SUM(cle.price_unit * cim.number_of_items) oec
1235: FROM okc_subclass_top_line stl,
1236: okc_line_styles_b lse2,
1237: okc_line_styles_b lse1,
1238: okc_k_items_v cim,
1239: okc_k_lines_v cle
1240: WHERE cle.cle_id = p_top_cle_id
1241: AND cle.dnz_chr_id = p_dnz_chr_id
1242: AND cle.id = cim.cle_id

Line 13924: okc_k_items_v itm,

13920: CURSOR get_asset_cost_csr (p_kle_id IN NUMBER) IS
13921: SELECT nvl(fab.cost,0) current_cost
13922: FROM fa_books fab,
13923: fa_book_controls fbc,
13924: okc_k_items_v itm,
13925: okc_k_lines_b kle,
13926: okc_line_styles_v lse
13927: WHERE fbc.book_class = 'CORPORATE'
13928: AND fab.book_type_code = fbc.book_type_code

Line 15623: okc_k_items_v cim,

15619: SELECT SUM(cle.price_unit * cim.number_of_items) asset_cost
15620: FROM okc_subclass_top_line stl,
15621: okc_line_styles_b lse2,
15622: okc_line_styles_b lse1,
15623: okc_k_items_v cim,
15624: okc_k_lines_v cle
15625: WHERE cle.cle_id = p_line_id
15626: AND cle.dnz_chr_id = p_dnz_chr_id
15627: AND cle.id = cim.cle_id

Line 15644: okc_k_items_v cim,

15640: FROM okc_subclass_top_line stl,
15641: okc_line_styles_b lse3,
15642: okc_line_styles_b lse2,
15643: okc_line_styles_b lse1,
15644: okc_k_items_v cim,
15645: okc_k_lines_b cle
15646: WHERE cle.dnz_chr_id = p_dnz_chr_id
15647: AND cle.dnz_chr_id = cim.dnz_chr_id
15648: AND cle.id = cim.cle_id

Line 15929: okc_k_items_v cim,

15925: FROM okc_subclass_top_line stl,
15926: okc_line_styles_b lse3,
15927: okc_line_styles_b lse2,
15928: okc_line_styles_b lse1,
15929: okc_k_items_v cim,
15930: okc_k_lines_b cle
15931: WHERE cle.dnz_chr_id = p_contract_id
15932: AND cle.dnz_chr_id = cim.dnz_chr_id
15933: AND cle.id = cim.cle_id