APPS.OKS_IBINT_PUB dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 3588: MTL_SYSTEM_ITEMS_B_KFV IT,

3584: CURSOR item_serviceable_csr(p_chr_id NUMBER,p_cust_prod_id NUMBER)
3585: IS
3586: SELECT 'Y'
3587: FROM CSI_ITEM_INSTANCES CII,
3588: MTL_SYSTEM_ITEMS_B_KFV IT,
3589: OKC_K_HEADERS_ALL_B OKH
3590: WHERE IT.inventory_item_id = CII.inventory_item_id
3591: AND IT.organization_id = OKH.inv_organization_id
3592: AND IT.serviceable_product_flag = 'Y'

Line 3647: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

3643: IS
3644: CURSOR l_inv_csr (p_product_item NUMBER)
3645: IS
3646: SELECT t.description NAME, b.concatenated_segments description
3647: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
3648: WHERE b.inventory_item_id = t.inventory_item_id
3649: AND b.organization_id = t.organization_id
3650: AND t.LANGUAGE = USERENV ('LANG')
3651: AND b.inventory_item_id = p_product_item