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

Line 956: FROM mtl_system_items

952: END IF;
953:
954: IF l_no_info THEN
955: SELECT Nvl(reservable_type,2) INTO l_reservable_type
956: FROM mtl_system_items
957: WHERE organization_id = p_organization_id
958: AND inventory_item_id = p_inventory_item_id;
959: g_is_item_reservable(p_inventory_item_id).org_id := p_organization_id;
960: IF (l_reservable_type = 1) THEN

Line 8665: FROM mtl_system_items_b

8661: ELSE
8662: --Bug7628989
8663: SELECT lot_control_code
8664: INTO lot_control_code
8665: FROM mtl_system_items_b
8666: WHERE inventory_item_id = l_inventory_item_id
8667: AND organization_id = l_organization_id;
8668:
8669: IF lot_control_code = 2 THEN

Line 10842: FROM mtl_system_items

10838: SELECT NVL(grade_control_flag, 'N')
10839: , NVL(lot_control_code, 1)
10840: , tracking_quantity_ind
10841: , lot_status_enabled
10842: FROM mtl_system_items
10843: WHERE inventory_item_id = item_id
10844: AND organization_id = org_id;
10845:
10846: BEGIN