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.CSM_MULTI_MOBQRY_PKG dependencies on MTL_SYSTEM_ITEMS_TL

Line 1426: FROM csp_available_parts_temp acc, mtl_system_items_kfv msik, mtl_system_items_tl tl ,fnd_lookup_values flv

1422: msik.concatenated_segments as item_name, msik.serial_number_control_code as serial_number_control_code,
1423: tl.description as description, msik.primary_uom_code as uom_code,msik.comms_nl_trackable_flag as comms_nl_trackable_flag,
1424: msik.material_billable_flag, msik.RESTRICT_LOCATORS_CODE, msik.LOCATION_CONTROL_CODE, msik.restrict_subinventories_code, msik.RECOVERED_PART_DISP_CODE
1425: ,flv.meaning as ship_method_meaning
1426: FROM csp_available_parts_temp acc, mtl_system_items_kfv msik, mtl_system_items_tl tl ,fnd_lookup_values flv
1427: WHERE msik.inventory_item_id = acc.supplied_item_id AND msik.organization_id = acc.organization_id
1428: AND acc.required_item_id=b_req_item_id
1429: AND msik.mtl_transactions_enabled_flag = 'Y' AND tl.inventory_item_id = msik.inventory_item_id
1430: AND tl.organization_id = msik.organization_id AND tl.LANGUAGE = asg_base.get_language(p_user_name)

Line 1778: FROM mtl_system_items_b msi, mtl_system_items_tl msi_tl

1774: msi.comms_nl_trackable_flag , msi.stock_enabled_flag, msi.attribute1 , msi.attribute2 , msi.attribute3 , msi.attribute4 , msi.attribute5 , msi.attribute6 ,
1775: msi.attribute7 , msi.attribute8 , msi.attribute9 , msi.attribute10 , msi.attribute11 , msi.attribute12, msi.attribute13 , msi.attribute14 , msi.attribute15 ,
1776: msi.attribute_category, msi.contract_item_type_code, msi.recovered_part_disp_code, msi.revision_qty_control_code, msi.RESTRICT_LOCATORS_CODE,
1777: msi.LOCATION_CONTROL_CODE, msi.LIST_PRICE_PER_UNIT, UPPER(msi.segment1) AS inventory_name_upper
1778: FROM mtl_system_items_b msi, mtl_system_items_tl msi_tl
1779: WHERE msi_tl.inventory_item_id = msi.inventory_item_id AND msi_tl.organization_id = msi.organization_id AND msi_tl.language = asg_base.get_language(p_user_name)
1780: AND msi.segment1 like l_item_name AND msi.organization_id=P_ORG_ID and rownum<=11 order by msi.segment1)
1781: --at client limiting to 10 items found , showing 11 for them to know that more exists here
1782: LOOP