APPS.INV_LOT_ATTR_PUB dependencies on MTL_SYSTEM_ITEMS

Line 37: FROM mtl_system_items

33: WHERE Grade_code = p_grade_code;
34:
35: CURSOR c_get_grade_flag IS
36: SELECT grade_control_flag
37: FROM mtl_system_items
38: WHERE inventory_item_id = p_inventory_item_id
39: AND organization_id = p_org_id;
40:
41:

Line 338: FROM mtl_system_items

334:
335: /* get shelf life code */
336: CURSOR c_get_shelf_life_code IS
337: SELECT shelf_life_code
338: FROM mtl_system_items
339: WHERE inventory_item_id = p_inventory_item_id
340: AND organization_id = p_org_id;
341:
342:

Line 596: FROM mtl_system_items

592:
593: /* get child lot enabled flag */
594: CURSOR c_child_lot_flag IS
595: SELECT p_child_lot_flag
596: FROM mtl_system_items
597: WHERE inventory_item_id = p_inventory_item_id
598: AND organization_id = p_org_id;
599:
600: l_api_version NUMBER;