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.OKS_COVERAGES_PVT dependencies on OKC_K_ITEMS

Line 574: FROM OKC_K_ITEMS_V

570: object1_id2,
571: JTOT_OBJECT1_CODE,
572: number_of_items,
573: exception_yn
574: FROM OKC_K_ITEMS_V
575: WHERE cle_Id=P_Id;
576:
577: --------------------------------------------------
578:

Line 2225: FROM Okc_K_ITEMS

2221: WHERE cle_Id=P_Parent_Id;
2222:
2223: CURSOR Item_Cur(P_Line_Id IN NUMBER)
2224: IS SELECT ID
2225: FROM Okc_K_ITEMS
2226: WHERE cle_Id=P_Line_Id;
2227:
2228: CURSOR RT_Cur(P_Rule_Id IN NUMBER)
2229: IS SELECT Tve_ID

Line 3819: FROM Okc_K_ITEMS

3815: WHERE cle_Id=P_Parent_Id;
3816:
3817: CURSOR Item_Cur(P_Line_Id IN NUMBER)
3818: IS SELECT ID
3819: FROM Okc_K_ITEMS
3820: WHERE cle_Id=P_Line_Id;
3821:
3822: CURSOR RT_Cur(P_Rule_Id IN NUMBER)
3823: IS SELECT Tve_ID

Line 4450: FROM OKC_K_LINES_V lines, OKC_K_ITEMS_V items

4446: SELECT lines.id,
4447: -- lines.start_date start_date,
4448: -- lines.end_date end_date,
4449: items.object1_id1
4450: FROM OKC_K_LINES_V lines, OKC_K_ITEMS_V items
4451: WHERE lines.cle_id = p_cle_id
4452: AND lines.lse_id IN(3,16,21)
4453: AND items.JTOT_OBJECT1_CODE = 'OKX_BUSIPROC'
4454: AND items.cle_id = lines.id ;

Line 4468: OKC_K_ITEMS items,

4464: NVL(kines.offset_period,0) offset_period,
4465: NVL(kines.allow_bt_discount,0) allow_bt_discount,
4466: NVL(kines.apply_default_timezone,0) apply_default_timezone
4467: FROM OKC_K_LINES_B lines,
4468: OKC_K_ITEMS items,
4469: OKS_K_LINES_B kines
4470: WHERE lines.cle_id = p_cle_id
4471: AND lines.id = items.cle_id
4472: AND items.jtot_object1_code = 'OKX_BUSIPROC'

Line 4498: OKC_K_ITEMS items,

4494: covtm.friday_yn friday_yn,
4495: covtm.saturday_yn saturday_yn,
4496: covtm.sunday_yn sunday_yn
4497: FROM OKC_K_LINES_B lines,
4498: OKC_K_ITEMS items,
4499: OKS_COVERAGE_TIMEZONES covtz,
4500: OKS_COVERAGE_TIMES covtm
4501: WHERE lines.id = p_id
4502: AND lines.lse_id IN (3,16,21)

Line 4559: OKC_K_ITEMS_V items

4555: ocv.resource_class resource_class
4556: FROM OKC_K_LINES_V lines,
4557: OKC_K_PARTY_ROLES_B party,
4558: OKC_CONTACTS_V ocv,
4559: OKC_K_ITEMS_V items
4560: WHERE lines.id = p_bp_line_id
4561: AND lines.lse_id IN (3,16,21)
4562: AND party.cle_id = lines.id
4563: AND items.cle_id = lines.id

Line 4581: OKC_K_ITEMS_V items,

4577: oksl.discount_percent discount_percent,
4578: txn.billing_type billing_type
4579: FROM OKC_K_LINES_V lines,
4580: OKS_K_LINES_B oksl,
4581: OKC_K_ITEMS_V items,
4582: okx_txn_billing_types_v txn
4583: WHERE lines.cle_id = p_cle_id
4584: AND oksl.cle_id = lines.id
4585: AND oksl.dnz_chr_id = lines.dnz_chr_id

Line 6305: OKC_K_ITEMS items,

6301: FROM
6302: OKC_K_LINES_B lines1,
6303: OKC_K_LINES_B lines2,
6304: OKC_K_LINES_B lines3,
6305: OKC_K_ITEMS items,
6306: OKC_RULE_GROUPS_B orgb,
6307: OKC_RULES_B rules,
6308: OKS_BILLRATE_SCHEDULES bills
6309: WHERE

Line 7004: okc_k_items items

7000: oks.apply_default_timezone apply_default_timezone,
7001: oks.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
7002: FROM okc_k_lines_b lines1,
7003: oks_k_lines_b oks,
7004: okc_k_items items
7005: WHERE lines1.cle_id = p_cle_id
7006: AND items.cle_id = lines1.id
7007: AND items.jtot_object1_code = 'OKX_BUSIPROC'
7008: AND oks.cle_id = lines1.id

Line 7034: okc_k_items items

7030: CURSOR CUR_GET_NEW_BP(p_cle_id IN NUMBER ,P_Object1_Id1 IN NUMBER , p_old_bp_id in number) IS
7031: SELECT lines1.id bp_line_id, lines1.dnz_chr_id dnz_chr_id,lines1.start_date start_date, lines1.end_date end_date,
7032: to_number(items.object1_id1) object1_id1
7033: FROM okc_k_lines_b lines1,
7034: okc_k_items items
7035: WHERE lines1.cle_id = p_cle_id
7036: AND items.cle_id = lines1.id
7037: AND items.jtot_object1_code = 'OKX_BUSIPROC'
7038: AND to_number(items.object1_id1) = p_object1_id1

Line 7085: okc_k_items BT_Item

7081: SELECT RT.ID,
7082: RT.DNZ_CHR_ID
7083: FROM okc_k_lines_b BT,
7084: okc_k_lines_B RT,
7085: okc_k_items BT_Item
7086: WHERE BT.id = P_Bp_line_Id
7087: AND BT.dnz_chr_id = P_new_dnz_chr_id
7088: AND BT.lse_id IN (3,16,21)
7089: AND BT.ID = RT.cle_id

Line 7151: okc_k_items items1,

7147: oks.discount_percent discount_percent
7148: FROM okc_k_lines_b lines1,
7149: okc_k_lines_b lines2,
7150: oks_k_lines_b oks,
7151: okc_k_items items1,
7152: okc_k_items items2
7153: WHERE lines1.id = p_id
7154: AND lines2.cle_id = lines1.id
7155: AND items1.cle_id = lines1.id

Line 7152: okc_k_items items2

7148: FROM okc_k_lines_b lines1,
7149: okc_k_lines_b lines2,
7150: oks_k_lines_b oks,
7151: okc_k_items items1,
7152: okc_k_items items2
7153: WHERE lines1.id = p_id
7154: AND lines2.cle_id = lines1.id
7155: AND items1.cle_id = lines1.id
7156: AND items2.cle_id = lines2.id

Line 7192: okc_k_items items1,

7188: to_number(items1.object1_id1) busi_proc_id,
7189: to_number(items2.object1_id1) bill_type_id
7190: FROM okc_k_lines_b lines1,
7191: okc_k_lines_b lines2,
7192: okc_k_items items1,
7193: okc_k_items items2
7194: WHERE lines1.id = p_id
7195: AND lines2.cle_id = lines1.id
7196: -- AND lines2.line_number = p_line_number

Line 7193: okc_k_items items2

7189: to_number(items2.object1_id1) bill_type_id
7190: FROM okc_k_lines_b lines1,
7191: okc_k_lines_b lines2,
7192: okc_k_items items1,
7193: okc_k_items items2
7194: WHERE lines1.id = p_id
7195: AND lines2.cle_id = lines1.id
7196: -- AND lines2.line_number = p_line_number
7197: AND items1.cle_id = lines1.id

Line 7253: okc_k_items BTY_ITEM,

7249: BRS.percent_over_list_price percent_over_list_price,
7250: BRS.object_version_number object_version_number --Added
7251: FROM okc_k_lines_b BTY,
7252: okc_k_lines_b BRT,
7253: okc_k_items BTY_ITEM,
7254: oks_billrate_schedules BRS
7255: WHERE BTY.id = p_id --274672627862321176435113785401106834939--
7256: AND BTY.lse_id IN (5,23,59)
7257: -- AND BRT.line_number = p_line_number

Line 7309: okc_k_items BTY_ITEM

7305: BRT.dnz_chr_id dnz_chr_id,
7306: TO_NUMBER(BTY_ITEM.object1_id1) bill_type_id
7307: FROM okc_k_lines_b BTY,
7308: okc_k_lines_b BRT,
7309: okc_k_items BTY_ITEM
7310: WHERE BTY.id =p_id
7311: -- AND BTY.line_Number = p_line_number
7312: AND BTY.lse_id IN (5,23,59)
7313: AND BTY.id = BTY_ITEM.cle_id

Line 7341: okc_k_items items

7337: IS
7338: SELECT lines1.id OLD_BP_LINE_ID,
7339: to_number(items.object1_id1) old_busi_proc_id
7340: FROM okc_k_lines_b lines1,
7341: okc_k_items items
7342: WHERE lines1.cle_id = p_cle_id
7343: AND lines1.lse_id IN (3,16,21)
7344: AND items.cle_id = lines1.id
7345: AND items.jtot_object1_code = 'OKX_BUSIPROC'

Line 7356: okc_k_items items,

7352: tze.timezone_id timezone_id,tze.default_yn default_yn,
7353: tze.dnz_chr_id tze_dnz_chr_id,tze.object_version_number tze_object_version_number,
7354: to_number(items.object1_id1) busi_proc_id
7355: FROM OKC_K_LINES_B lines1,
7356: okc_k_items items,
7357: oks_coverage_timezones tze
7358: WHERE lines1.id = p_id
7359: AND lines1.cle_id = p_cle_id
7360: AND lines1.lse_id IN (3,16,21)

Line 7405: okc_k_items items1

7401: IS
7402: SELECT lines1.id NEW_BP_LINE_ID, lines1.dnz_chr_id new_dnz_chr_id,
7403: to_number(items1.object1_id1) busi_proc_id
7404: FROM okc_k_lines_b lines1,
7405: okc_k_items items1
7406: WHERE lines1.cle_id = p_cle_id
7407: AND lines1.lse_id IN (3,16,21)
7408: AND items1.cle_id = lines1.id
7409: AND items1.jtot_object1_code = 'OKX_BUSIPROC'

Line 9326: -- OKC_K_ITEMS

9322: -- coverage --
9323: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
9324: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
9325: -- End --
9326: -- OKC_K_ITEMS
9327: l_cimv_tbl_in okc_contract_item_pub.cimv_tbl_type;
9328: l_cimv_tbl_out okc_contract_item_pub.cimv_tbl_type;
9329: --
9330: -- OKS_K_LINES_B

Line 9441: PRICED_ITEM_YN,uom_code from OKC_K_ITEMS

9437: and lse_id in ( 5,59,23);
9438:
9439: Cursor cur_item (p_id NUMBER) IS
9440: Select id,dnz_chr_id,jtot_object1_code,object1_id1,cle_id,chr_id,cle_id_for,exception_yn,
9441: PRICED_ITEM_YN,uom_code from OKC_K_ITEMS
9442: where cle_id = p_id;
9443:
9444:
9445: -- End Billing Type --

Line 9912: -- End OKC_K_ITEMS

9908: x_msg_count => l_msg_count,
9909: x_msg_data => l_msg_data,
9910: p_cimv_tbl => l_cimv_tbl_in,
9911: x_cimv_tbl => l_cimv_tbl_out );
9912: -- End OKC_K_ITEMS
9913: End if;
9914: cnt1:=0;
9915: For rec_oks_line in cur_oks_id (rec_bill.id) LOOP
9916:

Line 10413: FROM OKC_K_ITEMS_V

10409: WHERE cle_Id=P_cle_Id;
10410: -----------------------------------------------
10411: CURSOR CUR_ItemDet(P_Id IN NUMBER) IS
10412: SELECT ID
10413: FROM OKC_K_ITEMS_V
10414: WHERE cle_Id=P_Id;
10415: ------------------------------------------------
10416: CURSOR Cur_childline1(P_cle_Id IN NUMBER) IS
10417: SELECT ID,lse_id

Line 10447: l_old_bp_item_id OKC_K_ITEMS.ID%TYPE;

10443: l_old_coverage_id OKC_K_LINES_B.ID%TYPE;
10444: l_new_coverage_id OKC_K_LINES_B.ID%TYPE;
10445: l_old_bp_id OKC_K_LINES_B.ID%TYPE;
10446: l_new_bp_id OKC_K_LINES_B.ID%TYPE;
10447: l_old_bp_item_id OKC_K_ITEMS.ID%TYPE;
10448: l_new_bp_item_id OKC_K_ITEMS.ID%TYPE;
10449: l_old_rt_id OKC_K_LINES_B.ID%TYPE;
10450: l_new_rt_id OKC_K_LINES_B.ID%TYPE;
10451: l_new_rt_item_id OKC_K_ITEMS.ID%TYPE;

Line 10448: l_new_bp_item_id OKC_K_ITEMS.ID%TYPE;

10444: l_new_coverage_id OKC_K_LINES_B.ID%TYPE;
10445: l_old_bp_id OKC_K_LINES_B.ID%TYPE;
10446: l_new_bp_id OKC_K_LINES_B.ID%TYPE;
10447: l_old_bp_item_id OKC_K_ITEMS.ID%TYPE;
10448: l_new_bp_item_id OKC_K_ITEMS.ID%TYPE;
10449: l_old_rt_id OKC_K_LINES_B.ID%TYPE;
10450: l_new_rt_id OKC_K_LINES_B.ID%TYPE;
10451: l_new_rt_item_id OKC_K_ITEMS.ID%TYPE;
10452: l_old_rt_item_id OKC_K_ITEMS.ID%TYPE;

Line 10451: l_new_rt_item_id OKC_K_ITEMS.ID%TYPE;

10447: l_old_bp_item_id OKC_K_ITEMS.ID%TYPE;
10448: l_new_bp_item_id OKC_K_ITEMS.ID%TYPE;
10449: l_old_rt_id OKC_K_LINES_B.ID%TYPE;
10450: l_new_rt_id OKC_K_LINES_B.ID%TYPE;
10451: l_new_rt_item_id OKC_K_ITEMS.ID%TYPE;
10452: l_old_rt_item_id OKC_K_ITEMS.ID%TYPE;
10453: l_old_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;
10454: l_new_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;
10455: l_old_contact_id OKC_CONTACTS.ID%TYPE;

Line 10452: l_old_rt_item_id OKC_K_ITEMS.ID%TYPE;

10448: l_new_bp_item_id OKC_K_ITEMS.ID%TYPE;
10449: l_old_rt_id OKC_K_LINES_B.ID%TYPE;
10450: l_new_rt_id OKC_K_LINES_B.ID%TYPE;
10451: l_new_rt_item_id OKC_K_ITEMS.ID%TYPE;
10452: l_old_rt_item_id OKC_K_ITEMS.ID%TYPE;
10453: l_old_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;
10454: l_new_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;
10455: l_old_contact_id OKC_CONTACTS.ID%TYPE;
10456: l_new_contact_id OKC_CONTACTS.ID%TYPE;

Line 10734: -- This function is called by copy_standard_coverage for insertion into okc_k_items table

10730:
10731: END CREATE_OKC_LINE;
10732:
10733:
10734: -- This function is called by copy_standard_coverage for insertion into okc_k_items table
10735: FUNCTION CREATE_OKC_ITEM(p_new_item_id NUMBER,
10736: p_old_item_id NUMBER,
10737: p_cle_id NUMBER) return VARCHAR2 IS
10738:

Line 10743: INSERT INTO okc_k_items

10739: x_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
10740:
10741: BEGIN
10742:
10743: INSERT INTO okc_k_items
10744: ( ID,
10745: CLE_ID,
10746: CHR_ID,
10747: CLE_ID_FOR,

Line 10795: FROM OKC_K_ITEMS

10791: PROGRAM_APPLICATION_ID,
10792: PROGRAM_ID,
10793: PROGRAM_UPDATE_DATE,
10794: REQUEST_ID
10795: FROM OKC_K_ITEMS
10796: WHERE ID= p_old_item_id;
10797:
10798: RETURN x_return_status;
10799:

Line 11140: --Create entry in okc_k_items

11136: RAISE G_EXCEPTION_HALT_VALIDATION;
11137: END IF;
11138: IF tmp_crt_rec.lse_id in (5,59) -- For Billtypes
11139: THEN
11140: --Create entry in okc_k_items
11141: open CUR_ItemDet(l_old_rt_id);
11142: fetch CUR_ItemDet into l_old_rt_item_id;
11143: close CUR_ItemDet;
11144: l_new_rt_item_id :=okc_p_util.raw_to_number(sys_guid());