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.AHL_OSP_PO_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 3257: SELECT LIST_PRICE_PER_UNIT FROM MTL_SYSTEM_ITEMS_B MSIB, AHL_OSP_ORDER_LINES ospl

3253:
3254: FUNCTION Get_Item_Price(p_osp_line_id IN NUMBER) RETURN NUMBER IS
3255:
3256: CURSOR l_get_org_price_csr IS
3257: SELECT LIST_PRICE_PER_UNIT FROM MTL_SYSTEM_ITEMS_B MSIB, AHL_OSP_ORDER_LINES ospl
3258: WHERE MSIB.INVENTORY_ITEM_ID = ospl.service_item_id
3259: AND MSIB.ORGANIZATION_ID = ospl.inventory_org_id
3260: AND ospl.osp_order_line_id = p_osp_line_id;
3261: /*

Line 3292: FROM mtl_system_items_b

3288: ) RETURN NUMBER IS
3289:
3290: CURSOR get_exp_acct_item_csr(c_inv_org_id IN NUMBER, c_item_id IN NUMBER) IS
3291: SELECT expense_account
3292: FROM mtl_system_items_b
3293: WHERE organization_id = c_inv_org_id
3294: AND inventory_item_id = c_item_id;
3295:
3296: CURSOR get_mtl_acct_org_csr(c_inv_org_id IN NUMBER) IS