APPS.OE_VALIDATE_LOT_SERIAL dependencies on MTL_SYSTEM_ITEMS

Line 41: FROM mtl_system_items

37: tracking_quantity_ind,
38: secondary_uom_code,
39: serial_number_control_code,
40: secondary_default_ind
41: FROM mtl_system_items
42: WHERE organization_id = discrete_org_id
43: AND inventory_item_id = discrete_item_id;
44:
45: /*CURSOR c_opm_item ( discrete_org_id IN NUMBER INVCONV

Line 56: FROM mtl_system_items

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