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_RCV_CACHE dependencies on MTL_SYSTEM_ITEMS

Line 162: FROM mtl_system_items

158: INTO g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).primary_uom_code
159: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).secondary_uom_code
160: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).lot_control_code
161: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).serial_number_control_code
162: FROM mtl_system_items
163: WHERE organization_id = p_organization_id
164: AND inventory_item_id = p_inventory_item_id;
165: EXCEPTION
166: WHEN OTHERS THEN

Line 223: FROM mtl_system_items

219: INTO g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).primary_uom_code
220: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).secondary_uom_code
221: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).lot_control_code
222: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).serial_number_control_code
223: FROM mtl_system_items
224: WHERE organization_id = p_organization_id
225: AND inventory_item_id = p_inventory_item_id;
226: EXCEPTION
227: WHEN OTHERS THEN

Line 284: FROM mtl_system_items

280: INTO g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).primary_uom_code
281: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).secondary_uom_code
282: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).lot_control_code
283: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).serial_number_control_code
284: FROM mtl_system_items
285: WHERE organization_id = p_organization_id
286: AND inventory_item_id = p_inventory_item_id;
287: EXCEPTION
288: WHEN OTHERS THEN

Line 345: FROM mtl_system_items

341: INTO g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).primary_uom_code
342: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).secondary_uom_code
343: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).lot_control_code
344: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).serial_number_control_code
345: FROM mtl_system_items
346: WHERE organization_id = p_organization_id
347: AND inventory_item_id = p_inventory_item_id;
348: EXCEPTION
349: WHEN OTHERS THEN