APPS.GMD_ITEM_TECHNICAL_DATA_PUB dependencies on MTL_SYSTEM_ITEMS

Line 593: FROM mtl_system_items

589:
590: -- Bug 5350197
591: CURSOR check_item_is_valid(l_item_id NUMBER) IS
592: SELECT 1
593: FROM mtl_system_items
594: WHERE inventory_item_id = l_item_id
595: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE) AND NVL(END_DATE_ACTIVE,SYSDATE)
596: AND SERIAL_NUMBER_CONTROL_CODE = 1;
597: