APPS.OE_VALIDATE_LOT_SERIAL dependencies on MTL_SYSTEM_ITEMS

Line 43: FROM mtl_system_items

39: secondary_uom_code,
40: serial_number_control_code,
41: secondary_default_ind,
42: primary_uom_code --Bug 10021098
43: FROM mtl_system_items
44: WHERE organization_id = discrete_org_id
45: AND inventory_item_id = discrete_item_id;
46:
47: /*CURSOR c_opm_item ( discrete_org_id IN NUMBER INVCONV

Line 58: FROM mtl_system_items

54: , item_um2
55: FROM ic_item_mst
56: WHERE delete_mark = 0
57: AND item_no in (SELECT segment1
58: FROM mtl_system_items
59: WHERE organization_id = discrete_org_id
60: AND inventory_item_id = discrete_item_id); */
61:
62: CURSOR c_lot1 ( p_inventory_item_id in number, -- INVCONV bug 4099604