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_BILL_REC_PUB dependencies on MTL_SYSTEM_ITEMS

Line 373: ,mtl_system_items mtl

369:
370: CURSOR inv_item_csr(p_cle_id IN NUMBER) Is
371: SELECT primary_uom_code
372: FROM Okc_K_items Item
373: ,mtl_system_items mtl
374: ,okc_k_lines_b line
375: ,okc_k_headers_b hdr
376: WHERE item.cle_id = p_cle_id
377: AND line.id = item.cle_id

Line 925: ,mtl_system_items_b mtl --Okx_system_items_v mtl

921: CURSOR l_inv_item_csr(p_cle_id Number) Is
922: SELECT mtl.primary_uom_code,
923: line.dnz_chr_id
924: FROM Okc_K_items Item
925: ,mtl_system_items_b mtl --Okx_system_items_v mtl
926: ,okc_k_headers_b hdr
927: ,okc_k_lines_b line
928: WHERE item.cle_id = line.id --p_cle_id
929: AND line.id = p_cle_id

Line 7837: mtl_system_items_b mtl

7833: Select item.Object1_id1,
7834: mtl.usage_item_flag,
7835: mtl.service_item_flag
7836: From Okc_K_items Item,
7837: mtl_system_items_b mtl
7838: Where item.cle_id = p_cle_id
7839: And mtl.inventory_item_id = item.object1_id1;
7840:
7841: Cursor l_usage_csr(p_id Number)