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.INV_EBI_ITEM_HELPER dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 5159: FROM mtl_onhand_quantities_detail moq,mtl_cross_references_b mcr, mtl_parameters mp, mtl_system_items_kfv msik

5155: CURSOR c_get_bal_item_lst_pim IS
5156: SELECT inv_ebi_get_operational_attrs(gibp.inventory_item_id,gibp.concatenated_segments, gibp.organization_id,gibp.organization_code,NULL,NULL)
5157: FROM (
5158: SELECT DISTINCT mcr.inventory_item_id,msik.concatenated_segments,mcr.organization_id,mp.organization_code
5159: FROM mtl_onhand_quantities_detail moq,mtl_cross_references_b mcr, mtl_parameters mp, mtl_system_items_kfv msik
5160: WHERE mcr.inventory_item_id = moq.inventory_item_id
5161: AND mcr.organization_id = moq.organization_id
5162: AND mcr.organization_id = mp.organization_id
5163: AND msik.organization_id = moq.organization_id

Line 5172: FROM mtl_onhand_quantities_detail moq, mtl_parameters mp, mtl_system_items_kfv msik

5168:
5169: CURSOR c_get_bal_item_lst IS
5170: SELECT inv_ebi_get_operational_attrs(gib.inventory_item_id,gib.concatenated_segments, gib.organization_id,gib.organization_code,NULL,NULL)
5171: FROM (SELECT DISTINCT moq.inventory_item_id,msik.concatenated_segments,moq.organization_id,mp.organization_code
5172: FROM mtl_onhand_quantities_detail moq, mtl_parameters mp, mtl_system_items_kfv msik
5173: WHERE moq.organization_id = mp.organization_id
5174: AND msik.organization_id = moq.organization_id
5175: AND msik.inventory_item_id = moq.inventory_item_id
5176: AND moq.last_update_date >= l_from_date