DBA Data[Home] [Help]

APPS.OKS_IBINT_PUB dependencies on MTL_SYSTEM_ITEMS_TL

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