APPS.OKS_SUBSCRIPTION_PVT dependencies on OKC_K_LINES_B

Line 17: From okc_k_lines_b KL,

13: Cursor kl_cur Is
14: Select KL.dnz_chr_id, KL.start_date, NVL(KL.date_terminated - 1,KL.end_date) end_date,
15: KI.number_of_items, KI.uom_code,
16: NVL(MTL.contract_item_type_code,'NON-SUB'), MTL.coverage_schedule_id, MTL.comms_nl_trackable_flag
17: From okc_k_lines_b KL,
18: okc_k_items KI,
19: mtl_system_items MTL
20: Where KL.id = p_cle_id
21: and KI.cle_id = p_cle_id

Line 430: From okc_k_lines_b KL,

426: Cursor kl_cur Is
427: Select KL.dnz_chr_id, KL.start_date, NVL(KL.date_terminated - 1,KL.end_date) end_date,
428: KL.price_negotiated, KI.number_of_items, KI.uom_code,
429: NVL(MTL.contract_item_type_code,'NON-SUB')
430: From okc_k_lines_b KL,
431: okc_k_items KI,
432: mtl_system_items MTL
433: Where KL.id = p_cle_id
434: and KI.cle_id = p_cle_id

Line 1023: From okc_k_lines_b

1019: p_intent IN VARCHAR2
1020: ) IS
1021: Cursor tgt_chr_cur Is
1022: Select dnz_chr_id
1023: From okc_k_lines_b
1024: Where id = p_target_cle_id
1025: And lse_id = 46;
1026: Cursor src_line_cur Is
1027: Select id

Line 1028: From okc_k_lines_b

1024: Where id = p_target_cle_id
1025: And lse_id = 46;
1026: Cursor src_line_cur Is
1027: Select id
1028: From okc_k_lines_b
1029: Where id = p_source_cle_id
1030: And lse_id = 46;
1031: -- Pricing Parameters
1032: l_price_details_in OKS_QP_PKG.INPUT_DETAILS;

Line 1676: From okc_k_lines_b

1672: From oks_subscr_elements
1673: Where dnz_cle_id = p_cle_id;
1674: Cursor k_line_cur Is
1675: Select start_date, end_date
1676: From okc_k_lines_b
1677: Where id = p_cle_id;
1678: CURSOR l_get_hdrid_csr IS
1679: SELECT dnz_chr_id
1680: FROM okc_k_lines_b

Line 1680: FROM okc_k_lines_b

1676: From okc_k_lines_b
1677: Where id = p_cle_id;
1678: CURSOR l_get_hdrid_csr IS
1679: SELECT dnz_chr_id
1680: FROM okc_k_lines_b
1681: WHERE id = p_cle_id;
1682: l_quantity Number;
1683: l_uom_code Varchar2(10);
1684: l_cal_uom Varchar2(10);

Line 1859: From okc_k_lines_b

1855: p_termn_date IN DATE
1856: ) Return NUMBER IS
1857: Cursor k_line_cur Is
1858: Select start_date, end_date, price_negotiated
1859: From okc_k_lines_b
1860: Where id = p_cle_id
1861: And lse_id = 46;
1862: Cursor osh_cur Is
1863: Select item_type, frequency

Line 1873: FROM okc_k_lines_b

1869: Where dnz_cle_id = p_cle_id
1870: And (start_date < p_termn_date Or order_header_id Is Not Null);
1871: CURSOR l_get_hdrid_csr IS
1872: SELECT dnz_chr_id
1873: FROM okc_k_lines_b
1874: WHERE id = p_cle_id;
1875: l_act_start Date;
1876: l_act_end Date;
1877: l_start_date Date;