APPS.GMD_ITEM_TECHNICAL_DATA_PUB dependencies on MTL_SYSTEM_ITEMS

Line 513: FROM mtl_system_items

509:
510: -- Bug 5350197
511: CURSOR check_item_is_valid(l_item_id NUMBER) IS
512: SELECT 1
513: FROM mtl_system_items
514: WHERE inventory_item_id = l_item_id
515: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE) AND NVL(END_DATE_ACTIVE,SYSDATE)
516: AND SERIAL_NUMBER_CONTROL_CODE = 1;
517: