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.OKL_QA_DATA_INTEGRITY dependencies on MTL_SYSTEM_ITEMS

Line 4204: mtl_system_items mtl

4200: okc_k_lines_b item,
4201: okc_line_styles_b item_style,
4202: okc_line_styles_b top_style,
4203: okc_k_items kitem,
4204: mtl_system_items mtl
4205: WHERE top.dnz_chr_id = p_chr_id
4206: AND top.lse_id = top_style.id
4207: AND top_style.lty_code = 'FREE_FORM1'
4208: AND top.id = item.cle_id

Line 4339: FROM mtl_system_items mtl

4335:
4336:
4337: CURSOR serialized_csr (p_inv_item_id NUMBER, p_inventory_org_id NUMBER) IS
4338: SELECT 'X'
4339: FROM mtl_system_items mtl
4340: WHERE mtl.inventory_item_id = p_inv_item_id
4341: AND mtl.organization_id = p_inventory_org_id
4342: AND mtl.serial_number_control_code in (2,5,6);
4343:

Line 12413: FROM mtl_system_items

12409:
12410: CURSOR l_inv_item_csr(p_inv_item_id IN NUMBER,
12411: p_org_id IN NUMBER) IS
12412: SELECT asset_category_id
12413: FROM mtl_system_items
12414: WHERE inventory_item_id = p_inv_item_id
12415: AND organization_id = p_org_id;
12416:
12417: l_inv_item_rec l_inv_item_csr%ROWTYPE;