eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_IB_UTIL_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1932: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t

1928: CURSOR l_inv_csr (p_product_item NUMBER)
1929: IS
1930: SELECT t.description NAME,
1931: b.concatenated_segments description
1932: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
1933: WHERE b.inventory_item_id = t.inventory_item_id
1934: AND b.organization_id = t.organization_id
1935: AND t.LANGUAGE = USERENV ('LANG')
1936: AND b.inventory_item_id = p_product_item

Line 2558: From Mtl_system_items_b mtl

2554: Procedure get_srv_name(P_line_id Number, x_service_name Out NoCopy Varchar2, x_service_description Out NoCopy varchar2) Is
2555:
2556: Cursor get_name_csr Is
2557: Select fnd_flex_server.get_kfv_concat_segs_by_rowid('COMPACT', 401, 'SERV', 101, mtl.rowid), description
2558: From Mtl_system_items_b mtl
2559: , okc_k_items itm
2560: Where mtl.inventory_item_id = itm.object1_id1
2561: and mtl.organization_id = itm.object1_id2
2562: And itm.cle_id = p_line_id;