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

Line 77: FROM mtl_system_items

73: , l_item_id IN NUMBER) IS
74: SELECT tracking_quantity_ind
75: , lot_control_code
76: , grade_control_flag
77: FROM mtl_system_items
78: WHERE inventory_item_id = l_item_id
79: AND organization_id = l_org_id;
80: -- invConv changes end
81:

Line 2206: FROM mtl_system_items_b

2202: CURSOR get_item_info( l_org_id IN NUMBER
2203: , l_item_id IN NUMBER) IS
2204: SELECT tracking_quantity_ind
2205: , lot_control_code
2206: FROM mtl_system_items_b
2207: WHERE inventory_item_id = l_item_id
2208: AND organization_id = l_org_id;
2209: -- invConv changes end
2210:

Line 2235: -- from mtl_system_items_b

2231:
2232: -- invConv change : this is included in the above cursor.
2233: -- SELECT lot_control_code
2234: -- into l_lot_control
2235: -- from mtl_system_items_b
2236: -- where inventory_item_id = p_item_id
2237: -- and organization_id = p_org_id;
2238:
2239: -- Added the below for 6633612

Line 2939: from mtl_system_items_b

2935: , 9);
2936: END IF;
2937: SELECT lot_control_code
2938: into l_lot_control
2939: from mtl_system_items_b
2940: where inventory_item_id = p_item_id
2941: and organization_id = p_org_id;
2942:
2943: /* Added the below for bug 7193862 */