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 3224: SELECT LIST_PRICE_PER_UNIT FROM MTL_SYSTEM_ITEMS_B MSIB, AHL_OSP_ORDER_LINES ospl

3220:
3221: FUNCTION Get_Item_Price(p_osp_line_id IN NUMBER) RETURN NUMBER IS
3222:
3223: CURSOR l_get_org_price_csr IS
3224: SELECT LIST_PRICE_PER_UNIT FROM MTL_SYSTEM_ITEMS_B MSIB, AHL_OSP_ORDER_LINES ospl
3225: WHERE MSIB.INVENTORY_ITEM_ID = ospl.service_item_id
3226: AND MSIB.ORGANIZATION_ID = ospl.inventory_org_id
3227: AND ospl.osp_order_line_id = p_osp_line_id;
3228: /*

Line 3259: FROM mtl_system_items_b

3255: ) RETURN NUMBER IS
3256:
3257: CURSOR get_exp_acct_item_csr(c_inv_org_id IN NUMBER, c_item_id IN NUMBER) IS
3258: SELECT expense_account
3259: FROM mtl_system_items_b
3260: WHERE organization_id = c_inv_org_id
3261: AND inventory_item_id = c_item_id;
3262:
3263: CURSOR get_mtl_acct_org_csr(c_inv_org_id IN NUMBER) IS