APPS.CSL_MTL_SERIAL_NUMBERS_ACC_PKG dependencies on JTM_ACC_TABLE_S

Line 47: SELECT JTM_ACC_TABLE_S.NEXTVAL, INVENTORY_ITEM_ID, SERIAL_NUMBER, p_resource_id

43: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
44: END IF;
45:
46: /*Block insert every item from given subinventory/org not yet in acc table*/
47: SELECT JTM_ACC_TABLE_S.NEXTVAL, INVENTORY_ITEM_ID, SERIAL_NUMBER, p_resource_id
48: BULK COLLECT INTO sequences, items, serials, resources
49: FROM MTL_SERIAL_NUMBERS
50: WHERE CURRENT_STATUS IN (1,3)
51: AND ( CURRENT_SUBINVENTORY_CODE, CURRENT_ORGANIZATION_ID ) IN (