2773: --End bug#4928081
2774:
2775: Cursor l_item(p_object1_id1 Number, p_object1_id2 Varchar2) IS
2776: Select name
2777: From OKX_SYSTEM_ITEMS_V
2778: Where id1 = p_object1_id1
2779: and id2 = p_object1_id2
2780: and organization_id = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')
2781: and serviceable_product_flag='Y' ;
3245:
3246:
3247: Cursor l_line_name_csr (p_line_id Number,p_organization_id Number) IS
3248: Select sys.NAME LineName
3249: From OKX_SYSTEM_ITEMS_V sys
3250: ,OKC_K_ITEMS itm
3251: Where itm.CLE_ID = p_line_id
3252: and sys.ID1 = itm.OBJECT1_ID1
3253: and sys.ID2 = itm.OBJECT1_ID2;