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 138: FROM mtl_system_items

134: INTO g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).primary_uom_code
135: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).secondary_uom_code
136: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).lot_control_code
137: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).serial_number_control_code
138: FROM mtl_system_items
139: WHERE organization_id = p_organization_id
140: AND inventory_item_id = p_inventory_item_id;
141: EXCEPTION
142: WHEN OTHERS THEN

Line 199: FROM mtl_system_items

195: INTO g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).primary_uom_code
196: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).secondary_uom_code
197: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).lot_control_code
198: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).serial_number_control_code
199: FROM mtl_system_items
200: WHERE organization_id = p_organization_id
201: AND inventory_item_id = p_inventory_item_id;
202: EXCEPTION
203: WHEN OTHERS THEN

Line 260: FROM mtl_system_items

256: INTO g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).primary_uom_code
257: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).secondary_uom_code
258: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).lot_control_code
259: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).serial_number_control_code
260: FROM mtl_system_items
261: WHERE organization_id = p_organization_id
262: AND inventory_item_id = p_inventory_item_id;
263: EXCEPTION
264: WHEN OTHERS THEN

Line 321: FROM mtl_system_items

317: INTO g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).primary_uom_code
318: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).secondary_uom_code
319: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).lot_control_code
320: , g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).serial_number_control_code
321: FROM mtl_system_items
322: WHERE organization_id = p_organization_id
323: AND inventory_item_id = p_inventory_item_id;
324: EXCEPTION
325: WHEN OTHERS THEN