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

Line 358: FROM MTL_SYSTEM_ITEMS

354: IF p_uom_code IS NOT NULL THEN
355: BEGIN
356: SELECT Primary_Uom_Code
357: INTO l_primary_uom_code
358: FROM MTL_SYSTEM_ITEMS
359: WHERE Organization_Id = p_organization_id
360: AND Inventory_Item_Id = p_inventory_item_id;
361: EXCEPTION
362: WHEN no_data_found THEN

Line 672: FROM mtl_system_items

668: l_lot_control NUMBER;
669: CURSOR get_item_details( org_id IN NUMBER
670: , item_id IN NUMBER) IS
671: SELECT NVL(lot_control_code, 1)
672: FROM mtl_system_items
673: WHERE inventory_item_id = item_id
674: AND organization_id = org_id;
675:
676: l_demand_header_type NUMBER;

Line 948: FROM MTL_SYSTEM_ITEMS

944: IF p_uom_code IS NOT NULL THEN
945: BEGIN
946: SELECT Primary_Uom_Code
947: INTO l_primary_uom_code
948: FROM MTL_SYSTEM_ITEMS
949: WHERE Organization_Id = p_organization_id
950: AND Inventory_Item_Id = p_inventory_item_id;
951: EXCEPTION
952: WHEN no_data_found THEN

Line 1384: FROM mtl_system_items

1380: l_lot_control NUMBER;
1381: CURSOR get_item_details( org_id IN NUMBER
1382: , item_id IN NUMBER) IS
1383: SELECT NVL(lot_control_code, 1)
1384: FROM mtl_system_items
1385: WHERE inventory_item_id = item_id
1386: AND organization_id = org_id;
1387:
1388: l_demand_header_type NUMBER;

Line 1515: FROM MTL_SYSTEM_ITEMS

1511: IF p_uom_code IS NOT NULL THEN
1512: BEGIN
1513: SELECT Primary_Uom_Code
1514: INTO l_primary_uom_code
1515: FROM MTL_SYSTEM_ITEMS
1516: WHERE Organization_Id = p_organization_id
1517: AND Inventory_Item_Id = p_inventory_item_id;
1518: EXCEPTION
1519: WHEN no_data_found THEN