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 4531: mtl_system_items mtl

4527: okc_k_lines_b item,
4528: okc_line_styles_b item_style,
4529: okc_line_styles_b top_style,
4530: okc_k_items kitem,
4531: mtl_system_items mtl
4532: WHERE top.dnz_chr_id = p_chr_id
4533: AND top.lse_id = top_style.id
4534: AND top_style.lty_code = 'FREE_FORM1'
4535: AND top.id = item.cle_id

Line 4726: FROM mtl_system_items mtl

4722:
4723:
4724: CURSOR serialized_csr (p_inv_item_id NUMBER, p_inventory_org_id NUMBER) IS
4725: SELECT 'X'
4726: FROM mtl_system_items mtl
4727: WHERE mtl.inventory_item_id = p_inv_item_id
4728: AND mtl.organization_id = p_inventory_org_id
4729: AND mtl.serial_number_control_code in (2,5,6);
4730:

Line 12965: FROM mtl_system_items

12961:
12962: CURSOR l_inv_item_csr(p_inv_item_id IN NUMBER,
12963: p_org_id IN NUMBER) IS
12964: SELECT asset_category_id
12965: FROM mtl_system_items
12966: WHERE inventory_item_id = p_inv_item_id
12967: AND organization_id = p_org_id;
12968:
12969: l_inv_item_rec l_inv_item_csr%ROWTYPE;