APPS.OKS_QP_INT_PVT dependencies on OKC_K_ITEMS

Line 197: FROM okc_k_items

193: AND kle.ID = cleb.cle_id
194: AND NVL(kle.line_list_price, 0) > NVL(cleb.toplvl_adj_price,0);
195: CURSOR cs_subline_qty (cp_subline_id IN NUMBER) IS
196: SELECT number_of_items subline_qty
197: FROM okc_k_items
198: WHERE cle_id = cp_subline_id;
199: l_api_name CONSTANT VARCHAR2 (30) := 'get_subline_discount';
200: l_discount NUMBER := 0;
201: l_subline_qty NUMBER := 0;

Line 241: FROM okc_k_items

237: AND kle.ID = cleb.cle_id
238: AND NVL (kle.line_list_price, 0) < NVL (cleb.toplvl_adj_price, 0);
239: CURSOR cs_subline_qty(cp_subline_id IN NUMBER) IS
240: SELECT number_of_items subline_qty
241: FROM okc_k_items
242: WHERE cle_id = cp_subline_id;
243: l_api_name CONSTANT VARCHAR2(30):= 'get_subline_surcharge';
244: l_surcharge NUMBER := 0;
245: l_subline_qty NUMBER := 0;

Line 976: okc_k_items ki,

972: )
973: IS
974: SELECT 'x'
975: FROM okc_k_lines_b kl,
976: okc_k_items ki,
977: oks_subscr_header_b sh
978: WHERE kl.ID = p_subline_id
979: AND ki.cle_id = kl.ID
980: AND sh.instance_id = ki.object1_id1;

Line 1054: FROM okc_k_items

1050: )
1051: IS
1052: SELECT object1_id1,
1053: object1_id2
1054: FROM okc_k_items
1055: WHERE cle_id = c_cle_id;
1056:
1057: CURSOR l_cii_csr (
1058: c_instance_id NUMBER

Line 1090: l_object1_id1 okc_k_items.object1_id1%TYPE;

1086: l_cle_id NUMBER;
1087: l_lse_id NUMBER;
1088: l_dnz_chr_id NUMBER;
1089: l_inv_org_id NUMBER;
1090: l_object1_id1 okc_k_items.object1_id1%TYPE;
1091: l_object1_id2 okc_k_items.object1_id2%TYPE;
1092: l_inventory_item_id NUMBER;
1093: l_item_cle_id NUMBER;
1094: l_name VARCHAR2 (1000);

Line 1091: l_object1_id2 okc_k_items.object1_id2%TYPE;

1087: l_lse_id NUMBER;
1088: l_dnz_chr_id NUMBER;
1089: l_inv_org_id NUMBER;
1090: l_object1_id1 okc_k_items.object1_id1%TYPE;
1091: l_object1_id2 okc_k_items.object1_id2%TYPE;
1092: l_inventory_item_id NUMBER;
1093: l_item_cle_id NUMBER;
1094: l_name VARCHAR2 (1000);
1095: l_description VARCHAR2 (1000);

Line 2706: FROM okc_k_items_v

2702: p_subline_id NUMBER
2703: )
2704: IS
2705: SELECT number_of_items
2706: FROM okc_k_items_v
2707: WHERE cle_id = p_subline_id;
2708:
2709: l_num_items NUMBER;
2710: l_duration_qty NUMBER;