APPS.OKS_BILL_UTIL_PUB dependencies on OKX_SYSTEM_ITEMS_V

Line 2743: From OKX_SYSTEM_ITEMS_V

2739: --End bug#4928081
2740:
2741: Cursor l_item(p_object1_id1 Number, p_object1_id2 Varchar2) IS
2742: Select name
2743: From OKX_SYSTEM_ITEMS_V
2744: Where id1 = p_object1_id1
2745: and id2 = p_object1_id2
2746: and organization_id = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')
2747: and serviceable_product_flag='Y' ;

Line 3215: From OKX_SYSTEM_ITEMS_V sys

3211:
3212:
3213: Cursor l_line_name_csr (p_line_id Number,p_organization_id Number) IS
3214: Select sys.NAME LineName
3215: From OKX_SYSTEM_ITEMS_V sys
3216: ,OKC_K_ITEMS itm
3217: Where itm.CLE_ID = p_line_id
3218: and sys.ID1 = itm.OBJECT1_ID1
3219: and sys.ID2 = itm.OBJECT1_ID2;