APPS.OKS_QP_INT_PVT dependencies on OKC_K_ITEMS

Line 175: FROM okc_k_items

171: AND kle.ID = cleb.cle_id
172: AND NVL(kle.line_list_price, 0) > NVL(cleb.toplvl_adj_price,0);
173: CURSOR cs_subline_qty (cp_subline_id IN NUMBER) IS
174: SELECT number_of_items subline_qty
175: FROM okc_k_items
176: WHERE cle_id = cp_subline_id;
177: l_api_name CONSTANT VARCHAR2 (30) := 'get_subline_discount';
178: l_discount NUMBER := 0;
179: l_subline_qty NUMBER := 0;

Line 219: FROM okc_k_items

215: AND kle.ID = cleb.cle_id
216: AND NVL (kle.line_list_price, 0) < NVL (cleb.toplvl_adj_price, 0);
217: CURSOR cs_subline_qty(cp_subline_id IN NUMBER) IS
218: SELECT number_of_items subline_qty
219: FROM okc_k_items
220: WHERE cle_id = cp_subline_id;
221: l_api_name CONSTANT VARCHAR2(30):= 'get_subline_surcharge';
222: l_surcharge NUMBER := 0;
223: l_subline_qty NUMBER := 0;

Line 954: okc_k_items ki,

950: )
951: IS
952: SELECT 'x'
953: FROM okc_k_lines_b kl,
954: okc_k_items ki,
955: oks_subscr_header_b sh
956: WHERE kl.ID = p_subline_id
957: AND ki.cle_id = kl.ID
958: AND sh.instance_id = ki.object1_id1;

Line 1032: FROM okc_k_items

1028: )
1029: IS
1030: SELECT object1_id1,
1031: object1_id2
1032: FROM okc_k_items
1033: WHERE cle_id = c_cle_id;
1034:
1035: CURSOR l_cii_csr (
1036: c_instance_id NUMBER

Line 1068: l_object1_id1 okc_k_items.object1_id1%TYPE;

1064: l_cle_id NUMBER;
1065: l_lse_id NUMBER;
1066: l_dnz_chr_id NUMBER;
1067: l_inv_org_id NUMBER;
1068: l_object1_id1 okc_k_items.object1_id1%TYPE;
1069: l_object1_id2 okc_k_items.object1_id2%TYPE;
1070: l_inventory_item_id NUMBER;
1071: l_item_cle_id NUMBER;
1072: l_name VARCHAR2 (1000);

Line 1069: l_object1_id2 okc_k_items.object1_id2%TYPE;

1065: l_lse_id NUMBER;
1066: l_dnz_chr_id NUMBER;
1067: l_inv_org_id NUMBER;
1068: l_object1_id1 okc_k_items.object1_id1%TYPE;
1069: l_object1_id2 okc_k_items.object1_id2%TYPE;
1070: l_inventory_item_id NUMBER;
1071: l_item_cle_id NUMBER;
1072: l_name VARCHAR2 (1000);
1073: l_description VARCHAR2 (1000);

Line 2670: FROM okc_k_items_v

2666: p_subline_id NUMBER
2667: )
2668: IS
2669: SELECT number_of_items
2670: FROM okc_k_items_v
2671: WHERE cle_id = p_subline_id;
2672:
2673: l_num_items NUMBER;
2674: l_duration_qty NUMBER;