APPS.OKS_COVERAGES_PVT dependencies on OKC_K_ITEMS_V

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 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 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 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