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 6797: FROM mtl_onhand_quantities_detail moq,mtl_cross_references_b mcr, mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz

6793: CURSOR c_get_bal_item_lst_pim IS --8897962
6794: SELECT inv_ebi_get_operational_attrs(gibp.inventory_item_id,gibp.concatenated_segments, gibp.organization_id,gibp.organization_code,NULL,NULL)
6795: FROM (
6796: SELECT DISTINCT mcr.inventory_item_id,msik.concatenated_segments,moq.organization_id,mp.organization_code
6797: FROM mtl_onhand_quantities_detail moq,mtl_cross_references_b mcr, mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz
6798: WHERE mcr.inventory_item_id = moq.inventory_item_id
6799: --AND mcr.organization_id = moq.organization_id
6800: AND moq.organization_id = mp.organization_id
6801: AND msik.organization_id = moq.organization_id

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

6807:
6808: CURSOR c_get_bal_item_lst IS
6809: SELECT inv_ebi_get_operational_attrs(gib.inventory_item_id,gib.concatenated_segments, gib.organization_id,gib.organization_code,NULL,NULL)
6810: FROM (SELECT DISTINCT moq.inventory_item_id,msik.concatenated_segments,moq.organization_id,mp.organization_code
6811: FROM mtl_onhand_quantities_detail moq, mtl_parameters mp, mtl_system_items_kfv msik
6812: WHERE moq.organization_id = mp.organization_id
6813: AND msik.organization_id = moq.organization_id
6814: AND msik.inventory_item_id = moq.inventory_item_id
6815: AND moq.last_update_date >= l_from_date